ISSUES WITH SUMIF WITH DATE CRITERIA

ROHIT SARDESAI

I have a sheet wherein the data is getting populated by way of form. I am trying to create sheet summary which tells me the qty input done in last 30 days and instances

Problem with sumif formula.docx

for last 30 days using Sumif and Cuntif formula.

I get wrong answers.

Need help to determine if my formula is right

=SUMIF([DATE OF CONCRETE]:[DATE OF CONCRETE], <=TODAY(-30), [CONCRETE QTY]:[CONCRETE QTY])

=COUNTIF([DATE OF CONCRETE]:[DATE OF CONCRETE], <=TODAY(-30))

Paul Newcome

If you are wanting to count how many have been submitted in the past 30 days, you will need to use something along the lines of...

=COUNTIFS([DATE OF CONCRETE]:[DATE OF CONCRETE], AND(@cell >=TODAY(-30), @cell <= TODAY()))