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
Last edited by jpeirano; 03-10-2011 at 01:34 AM.
For January,
=SUMPRODUCT(--(MONTH(Sheet1!A2:A11)=1), Sheet1!C2:C11)
This is pretty much what pivot tables were designed to do.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
This is what I typed, does not work:Originally Posted by shg
=SUMPRODUCT(--(jan(Income!A2:A11)=1),Income!C2:C11)
Not jan... MONTH (that's the formula name).
=SUMPRODUCT(--(MONTH(Income!A2:A11)=1),Income!C2:C11)
"Relax. What is mind? No matter. What is matter? Never mind!"
Thank you it's working now, please forgive me second day using excel.
I got that if I want Feb. just change the =1 to =2
Where on the web do I go to learn how to write formulas, and how to lay them out; for example I dont know why the -- in front of this formula and how to know what and hoe to put in () first ext. Also why cant I call out the entire colum instead of A2:A11 I noticed that going dow the colum I had to increase the A11 and C11 by 1 in order to work for the rest ???
can you direct me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks