software

Hi,
Can anyone help me. I have an Excel Worksheet that looks like this:Date Type Amount

1-2-06 RENT 250
3-2-06 GOODS 140
5-2-06 RENT 450
6-2-06 TELEPHONES 70
2-3-06 RENT 300
7-3-06 GOODS 220I want to set up a summary table which adds the values via grouped typed per
month, working dynamically as data is added in the above worksheet
using the =sumproduct function.
I can add the totals per type using:
=SUMPRODUCT(($C$3:$C$100)*(B3:B100=E3)) where E3 is RENT
but I need to add another criteria using dates for example 1/2/2006gt;= and
lt;=28/2/2006 for Feb. and so forth.
For Example my table should look like this:Month RENT GOODS TELEPHONES

Feb.
March
AprilThanks
Ange
=SUMPRODUCT(($C$3:$C$100)*(B3:B100=E3)*(MONTH(A3:A 100)=2)

for Feb

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Ange Kappasquot; gt; wrote in message
...
gt; Hi,
gt; Can anyone help me. I have an Excel Worksheet that looks like
this:
gt;
gt;
gt; Date Type Amount
gt;
gt; 1-2-06 RENT 250
gt; 3-2-06 GOODS 140
gt; 5-2-06 RENT 450
gt; 6-2-06 TELEPHONES 70
gt; 2-3-06 RENT 300
gt; 7-3-06 GOODS 220
gt;
gt;
gt; I want to set up a summary table which adds the values via grouped typed
per
gt; month, working dynamically as data is added in the above worksheet
gt; using the =sumproduct function.
gt; I can add the totals per type using:
gt; =SUMPRODUCT(($C$3:$C$100)*(B3:B100=E3)) where E3 is RENT
gt; but I need to add another criteria using dates for example 1/2/2006gt;= and
gt; lt;=28/2/2006 for Feb. and so forth.
gt; For Example my table should look like this:
gt;
gt;
gt; Month RENT GOODS TELEPHONES
gt;
gt; Feb.
gt; March
gt; April
gt;
gt;
gt; Thanks
gt; Ange
gt;
gt;