SumIf ( range, criteria, sum_range )

A

andré C.

Hi,

i'm using 3 columns in excel 2007

"dates" - "code" - "money"

I use sumIF to get the total of money for each code. This works great.

But I would like to do so between two dates from column "dates".

To sumIF the table between two dates...

How could I do this ?


Thanks,

Andy
 
B

Barb Reinhardt

You need to do something like this

=SUMPRODUCT(--(A2:A12>DATE(2009,2,1)),--(A2:A12<=DATE(2009,3,1)),--(B2:B12="Code"),(C2:C12))

Assume Dates are in A2:A12, Codes are in B2:B12 and $$ is in C2:C12.

HTH,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIf( range, criteria, sum_range ) 3
SUMIF with the criteria range 4
sumif wildcard for text and numbers 2
SUMIF criteria 1
Using a range with SUMIF 3
Dynamic Named Range 4
Multiple Criteria for SumIf 7
sumif with multiple critera range and sum_range 5

Top