SUMIFS with multiple criteria per quarter

becky.walker

Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1.

Columns:

• National_local - want to only find those designated "national"
• Start_date - only need between 1/1/2025 - 3/31/2025
• Reach - need the summation of this column if the other two criteria are true.

I feel like I'm kind of close but maybe not? Like I said, I've tried too many times and have just confused myself at this point.

Last formula I tried:

• =SUMIFS([Start_Date]:[Start_Date], AND(@cell >= DATE(2025, 1, 1), @cell <= DATE(2025, 3, 31)), [National_Local]:[National_Local], "national", [Reach]:[Reach])
• It resulted in an invalid operation

Any help/answers would be greatly appreciated!

Darren Mullen

@becky.walker SUMIFS needs a range to sum over first in the formula:

• =SUMIFS([Reach]:[Reach],[Start_Date]:[Start_Date], AND(@cell >= DATE(2025, 1, 1), @cell <= DATE(2025, 3, 31)), [National_Local]:[National_Local], "national")

Darren Mullen

@becky.walker SUMIFS needs a range to sum over first in the formula:

• =SUMIFS([Reach]:[Reach],[Start_Date]:[Start_Date], AND(@cell >= DATE(2025, 1, 1), @cell <= DATE(2025, 3, 31)), [National_Local]:[National_Local], "national")

becky.walker

@Darren Mullen THANK YOU!! That was what I needed!