Thread: [Solved] Macro Excel
View Single Post
 
Old 07-14-2011, 01:43 PM
pkrishna pkrishna is offline Windows Vista Office 2007
Novice
 
Join Date: Jul 2011
Posts: 16
pkrishna is on a distinguished road
Default

It is not very clear to me, but take a look at the following:

Col:ACol:BCol:CCol:ACol:BCol:CCol:ACol:BCol:CCol:ACol:BCol:CCol:ACol:BRow:2JanFebMarAprMayJunRow:3A

7B0G5B3G6B3Row:4B6G4A6A5A0A6Row:5C9C0B7G0B4A7Row:6A5B6C7C7A9G8Row:7B2A2G4A3G5A9Row:8G2B3A4B6A0A2Row:9A

2G7B1A1B2B3Row:10Row:11JanFebMarAprMayJunRow:12A142109924Row:13B898966Row:14C907700Row:15G21190118Bear with the crummy notation I had to employ to designate the Rows and Columns.In your case each of the monthly numbers and categories inside a box will be on a separate worksheet.Note that the category order in each worksheet is different.The summarized information is presented in the second table.The formula here is: =SUMIF(C$3:C$9,$B12,D$3$9) - for "A-Jan"Explanation: SumIF function takes three arguments. A range foe the criteria, the Criteria, and the Range to be summedHere the number 14 for A-Jan is arrived at by considering the range c$3-c$9, comparing with the value in $B12 ("A") and if there is a match, summing the corresponding entry in the range D$3-D$9The '$' before the row number or column designation freeze the value from being incremented as you move across or down.So, the number 11 for G-May is obtained by =SUMIF(K$3:K$9,$B15,L$3:L$9)This is trivial if you have some experience with Excel, but would look intimidating for a noviceLet me know if it is clear enough.
Reply With Quote