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.
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.