ISSUES WITH SUMIF WITH DATE CRITERIA

Options

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

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!