SUMIFS and dates

  • Thread starter Thread starter JLR-Mart
  • Start date Start date
J

JLR-Mart

I have some data and wish to use the sumifs function to add up sums when a
criteria is true and the date is less than a month ago. I have tried using
date-30 to no avail. Any suggestions?
 
Hi

Something like the following, with dates in A, Criteria in B and Values in
C.
I put 01 Jan 2009 in I1 and 01 Feb in J1

=SUMIFS(C2:C5,B2:B5,"A",A2:A5,">="&I1,A2:A5,"<"&J1)
 
I've used:

=SUMIFS(Current!F3:F1048576,Current!D3:D1048576,"Petrol",Current!A3:A1048576,">="&Current!H2)

Where the content of Current!H2 = today()-30 (which equals 16/03/09)

BUT that doesn't result in a valid result.

Any ideas?
 
There's nothing wrong with your syntax, so it must be your data.

"doesn't result in a valid result" doesn't give us much to go on. What
result did you get, and what did you expect?

Regards,
Fred.
 
Back
Top