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

[@AlexanderYoder]

Best Sheets Channel thusfar!

[@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"

[@GV-gn3mj]

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

[@berthony65]

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

[@francisb3623]

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

[@alisonhowd8034]

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

[@moesadr3342]

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?

[@bountyonmyhead]

Damn this was so much help. Thank you

[@johndanielvillanueva8604]

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

[@rachelwhitton13]

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

[@jeffkabs2394]

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?

[@agnieszkawojtyla1962]

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

[@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!

[@vismaior7844]

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.

[@anumanth16111]

i cdnt find description to download the this sheet

[@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

[@sendingittome]

where's the link in the description?

[@joseelizondo373]

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

[@francisb3623]

i don't see it in description

[@alexaflores1957]

Thank u so much ✨

[@Jess_Bishop]

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?

[@cole18k95]

You are goated

[@chrisr.9258]

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

[@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!

[@silviamarinlopez5003]

You need to add more paranthesis, Z1: Z1={(A1)+[SUM(B1:F1)]+[SUM (M1:S1)]} I sued diffrent parenthesis types to show what needs to kinda go together as a group but you can just use the same type "(_)"

[@noeter]

=SUM(A1+[B1:F1]+{M1:S1})

[@JR-ci6oc]

how do you line break inside formula

[@hustlesheets]

option + enter on a mac! i think alt + enter on a PC - lmk if that works :)

[@lissetterobalino2106]

I need monthly

[@rajshreey]

your voice is so low

[@comebackcs]

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

[@hustlesheets]

😂

[@boxerfencer]

Where's the download link promissed in the description?

[@hustlesheets]

? lol

[@hustlesheets]

If there was a download link for this video it would be a purchase only anyway. Are you going to purchase it?

[@boxerfencer]

@@hustlesheets no, why would that be presumed? There was no mention of purchasing in the video. From my perspective, it isn't acceptable seeing as I'd have to configure everything anyway to work with the inventory control system I've already created. Thanks anyway.

[@lonnybranstuder4386]

o