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

Advertisements

D

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('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('Jan:Dec'!$G$5:$AK$20)))

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top