# Sum multiple sheets?

K

#### 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"

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"

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

D

#### Domenic

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!