Need Formula

[jpeirano]

Sheet1 is named Invoice

Colum A has Dates, Colum B has Invoice #, Colum C has Amount
1/31/2011 001 $20.00


Sheet3 is named Report

In B3 of the Report sheet I need the sum of the amounts found in Colum C of the invoice sheet, but only the ones that are from January.

In B4 of the Report sheet I need the sum of the amounts found in Colum C of the invoice sheet, but only the ones that are from February.

B5 March
B6 April, etc.

Thank you in advace

[shg]

Duplicate post, thread closed.

Please take a few minutes to read the forum rules about both duplicate posting and thread titles.

Thanks.