Summing based on multiple criteria - please help!!!

E

esrade

Hi - I am ripping my hair over this one because it seems like it
should be simple but I cannot get it to work.

I have a monthly report which I need to auto populate, based on the
new monthly data. The data will look something like this:

Date --- Type --- Amount
-------------------------
1/1/03 001 $100.00
1/1/03 001 $100.00
1/1/03 003 $50.00
1/2/03 001 $80.00
1/2/03 002 $50.00
1/2/03 003 $100.00
1/3/03 004 $50.00

The report sums up each day according to the type - types 1 and 2 are
in Column A and types 3 and 4 are in Column B. In other words, Column
A for 1/1/03 would be $200.00 but on 1/2/03 it would be $130.00.

I tried the conditional sum wizard and it's just coming up with zero
(literally). The SUMIF works on one condition but not two.

If it makes any difference, I am using Excel 97 and 2002 (I have to
get it to work on both desktops). Any suggestions?
Thanks.
 
D

Don Guillett

something like
=sumproduct((month(rngA)=1)*(rngB="001")*rngC)
range sizes must match ie a1:a20 b1:b20
 

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

Top