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
Bookmarks