|Posted by:||Dick (bobdel…@yahoo.com)|
|Date:||Tue, 18 Jan 2011|
My spreadsheet has 2 sheets, sheet1 & sheet2
Sheet1 has in column A a list of numbers, Column B the date, Column C
Sheet2 has the same numbers in Column A and the months in B, C, D, E,
F, etc... (12 months)
I'd like for excel to Sum Column C (Sheet1) by matching the SAME
numbers in Column A, with the Same month in Column B and total the
amounts in Column C and put the results in Sheet2 next to the SAME
number and the Same month.
Sheet1 would look like:
Column A Column B Column C
Number Date Amount
1234 1/1/2011 1
1234 1/5/2011 1
5678 1/10/2011 1
1234 1/20/2011 1
Sheet 2 would look like:
Column A Column B Column C Column D etc..
Number Jan. Feb. March etc...
1234 3 0 0
Thanks in Advance!!!