Sum multiple sheets?

[Ken]

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 D520 ... 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

 

[Domenic]

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('Janec'!$A$5:$A$20)=A5,IF(THREED('Janec'!$G$5:$AK$20)=
"P",1)))

E5, copied down:

=SUM(IF(THREED('Janec'!$A$5:$A$20)=A5,THREED('Janec'!$G$5:$AK$20)))

Hope this helps!