#UNPARSEABLE Sumifs

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))))



Tags:

Answers

  • RickyT
    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.


    Ricky T

    Gov Contractor for USSF

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!