SUMIF and a criteria range

  • Thread starter Thread starter Fredde
  • Start date Start date
F

Fredde

Hi,

I would like to use the SUMIF statement for summarizing when the criteria is
a range and not a fixed value.

Example: I have entered several invoices in column A, Arrival date in column
B. On a different sheet I would like to summarize the invoices that have
invoicedate between the first of and the last date of the month.

Can this be done with SUMIF or is there a another way to fix this?

Best regards

Fredde
 
Fredde,

What month is "the month"?

Current month:
=SUMPRODUCT(--(MONTH(A4:A1000)=MONTH(TODAY())),B4:B1000)

Any month with month # in D1:
=SUMPRODUCT(--(MONTH(A1:A1000)=D1),B1:B1000)

HTH
Anders Silven
 
You can always use Sumif twice:

=SUMIF(A1:A10,">=2/1/2004",B1:B10)-SUMIF(A1:A10,">=3/1/2004",B1:B10)
 
Back
Top