Sum If

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am trying to sum certain date ranges by using a sum if
statement. The formula below is not giving me any results.
What am I doing wrong? Is there a better way to approach
this?

=SUMIF(DATA!AB:AB,">=12/1/1903<=12/31/1903",DATA!W:W)

I am doing this for each month of the calendar year to sum
sales.

Thank you,
Jason
 
Jason said:
I am trying to sum certain date ranges by using a sum if
statement. The formula below is not giving me any results.
What am I doing wrong? Is there a better way to approach
this?

=SUMIF(DATA!AB:AB,">=12/1/1903<=12/31/1903",DATA!W:W)

I am doing this for each month of the calendar year to sum
sales.

Thank you,
Jason
Click to expand...

SUMIF can only take one criterion, whereas you need two (one for >= and the
other for <=). You can use SUMPRODUCT with multiple criteria, but not on
whole column ranges. Try something like:
=SUMPRODUCT((DATA!A1:A100>=DATE(1903,12,1))*(DATA!A1:A100<=DATE(1903,12,31))
*DATA!W1:W100)
 
Jason

One way:

=SUMPRODUCT((Data!AB2:AB13>=DATE(1903,12,1))*(Data!AB2:AB13<=DATE(1903,12,31
))*Data!W2:W13)
 
Back
Top