Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum multiple sheets?
Excel2003
I have 13 WorkSheets ... Jan, Feb, Mar - Dec & 2008. Each "Month" WorkSheet: Range A5:A20 ... a person Name (random sort) Range G4:AK4 ... is days of month 1-31 Range G5:AK5 ... contains a code "P" or a "numeric" for each persons Name The "2008" WorkSheet: Range A5:A20 ... contains same persons "Name" (random sort) I wish formula in WorkSheet "2008" Range D5:D20 ... Let's start with D5 1: look in each of 12 Month WorkSheets (Jan, Feb, Mar etc) ... Range G5:AK5 2: locate persons name found in Cell A5 of WorkSheet "2008" 3: Return total "Count" of all "P" codes I wish formula in WorkSheet "2008" Range E5:E20 ... Let's start with E5 1: look in each of 12 Month WorkSheets (Jan, Feb, Mar etc) ... Range G5:AK5 2: locate persons name found in Cell A5 of WorkSheet "2008" 3: Return total "SUM" of all "numerics" That's it ... Hope I have explained clear enough? My "Thanks" in advance for all those that are intimate with Excel & support these boards. Kha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum multiple sheets?
Download and install the free add-in, Morefunc.xll...
http://xcell05.free.fr/english/index.html Then try the following formulas, which need to be confirmed with CONTROL+SHIFT+ENTER... D5, copied down: =SUM(IF(THREED('Jan:Dec'!$A$5:$A$20)=A5,IF(THREED( 'Jan:Dec'!$G$5:$AK$20)= "P",1))) E5, copied down: =SUM(IF(THREED('Jan:Dec'!$A$5:$A$20)=A5,THREED('Ja n:Dec'!$G$5:$AK$20))) Hope this helps! In article , Ken wrote: Excel2003 I have 13 WorkSheets ... Jan, Feb, Mar - Dec & 2008. Each "Month" WorkSheet: Range A5:A20 ... a person Name (random sort) Range G4:AK4 ... is days of month 1-31 Range G5:AK5 ... contains a code "P" or a "numeric" for each persons Name The "2008" WorkSheet: Range A5:A20 ... contains same persons "Name" (random sort) I wish formula in WorkSheet "2008" Range D5:D20 ... Let's start with D5 1: look in each of 12 Month WorkSheets (Jan, Feb, Mar etc) ... Range G5:AK5 2: locate persons name found in Cell A5 of WorkSheet "2008" 3: Return total "Count" of all "P" codes I wish formula in WorkSheet "2008" Range E5:E20 ... Let's start with E5 1: look in each of 12 Month WorkSheets (Jan, Feb, Mar etc) ... Range G5:AK5 2: locate persons name found in Cell A5 of WorkSheet "2008" 3: Return total "SUM" of all "numerics" That's it ... Hope I have explained clear enough? My "Thanks" in advance for all those that are intimate with Excel & support these boards. Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) |