#UNPARSEABLE Sumifs

Drea Mora

My sumif formula keeps coming up unparseable and i can't figure out why. I'm not even getting the highlighted frame for when I identify the column I want to be summed. What am I doing wrong?

=SUMIFS([# of Car Seats]:[# of Car Seats], [Date Distributed]:[Date Distributed], AND(@cell >= DATE(2023, 10, 1), AND(@cell <= DATE(2024, 9, 30))))

RickyT

So it looks like its your first criteria, You could Try this :

=SUMIFS([# of Car Seats]:[# of Car Seats], NOT(ISBLANK(column@row)) , [Date Distributed]:[Date Distributed], AND(@cell >= DATE(2023, 10, 1), AND(@cell <= DATE(2024, 9, 30))))

If that wont work youll have to tinker with that section I added.