How to SUMIFS with Date Range & Multiple Criteria (Year to date, month to date) in Google Sheets

[johndanielvillanueva]

Please increase the volume of your audio. It's hard to hear when I'm working outside. Great videos! Thank you!

[alisonhowd]

Great instructional video!!!

Is it possible to get the cheat sheet link that was mentioned in the video?

[rachelwhitton]

I"m having trouble with the week-to-date formula. Do you have another video that explains this formula more in depth?

[vismaior]

This was extremely helpful - Thank you. The only question I have is why did you "hard code" the year in the YTD formula instead of using the YEAR() function? Perhaps it is not possible, but as it is you must edit that formula every year.

[kpoliey]

This was amazing! How do I choose a start date from one cell and an end date in another cell. I've added additional criteria in the formula you wrote, but it is not working for me. Thank you so much!

[joseelizondo]

Very helpful video… I’ve been trying to accomplish the week formula.

Whenever you get a chance .. I really want to know how to get similar data in cells … like duplicates but similar.

The goal is to get values like:

Cell : A1 = FGH012
Cell: x = FGHO12

Zero instead of letter O.

Thanks a lot in advance

[GV-gnmj]

Hi, thanks for the video. So, the "&" should be used wih ifs, averageifs, countifs functions as well or just with sumifs?

[thespaceghetto]

First off, thank you so much for all your videos. Extremely helpful. I like to follow along with the steps but I always have to come up with my own dummy data. It would be awesome if you could share the datasets that you're using so we can build the sheets along with you

[berthony]

Michael, good day, do you happen to know how to date range in the sheet tab. Nothing too complicated, just would like to go from 1-31 of Oct per se. Thanks

[Jess_Smith]

Your video is the only one that went over multiple different sets of criterias making it super valuable for what I need. Thank you so much for putting this up!
You showed how to indicate in a formula the “not empty” by using “<>”, but what if what I want to do is the opposite? I need to get results for column A only when column B is empty. How do I put that in a formula?

[moesadr]

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

[popocaboudoir]

Are you able to use COUNTIFS in a longer query formula? Like the ones from your Building a Professional Dashboard video? I have one section of my dashboard where I want to count only the cells with certain word, but keep getting errors when I try to do "countif" instead of just "count"

[francisb]

What version of google sheets is this. My drop downs have a bubble format which looks messy to me. How can i remove this

[jeffkabs]

Hello,

I would like to create a workbook for a savings and credit cooperative. This workbook would need to auto-update with years, past, present, and future months. The months would need to range from 2023 to infinite, and the years would need to range from 2023 to infinite as well. The workbook would need to track member id or account names and payments made of deposits, savings, personal accounts, loans received, loan payments, etc. Is this something you can help me with?

[anumanth]

i cdnt find description to download the this sheet

[GeorgeYanTiger]

How to add two SUMs together in one cell? for example: I tried to put two sums into cell Z1: Z1=A1+SUM(B1:F1)+SUM (M1:S1). Google sheet wouldn't allow me to do it. Your help would be highly appreciated. Thanks!

[agnieszkawojtyla]

I would like date to be a drop down, how can I do it with sum ifs?

[sendingittome]

where's the link in the description?

[comebackcs]

confusing bro... but tnx for trying! I better go ask chat GPT

[chrisr.]

Hey bro can I hire you to do something like this for me