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 |
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) |