SUMIF and a criteria range

[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

 

[Don Guillett]

Pretty simple. Did you try before asking?
=SUMIF(A:A,G15,C:C)

 

[Anders S]

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

 

[Jim Rech]

You can always use Sumif twice:

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