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!
