=SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon,
Carrie'!C4:C35)+SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon,
Carrie'!D4:D35)+SUMPRODUCT('Deacon, Carrie'!E4:E35,'Deacon,
Carrie'!F4:F35)

I'm using the formula above to calculate some stats for a call center.
On a master "group summary page", I need to get the sum of the results
of this formula from 20 worksheets. Other than duplicating the formula
and changing the names, is there a faster way to do this? The cell
references are identical for all, worksheets just the names change.

The only thing I can think of is "(formula using name 1) + (formula
using name 2)..." and so on for every sheet in the book. This will be
incredibly long and it seems to me there has to be a better way. Any
ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=466391

I would copy this formula into the *same* cell on each of your 20 sheets,
say A1:

=SUMPRODUCT(((B4:B35)*(C4:C35))+((B4:B35)*(D4:D35) )+((E4:E35)*(F4:F35)))

Then, insert a blank sheet before your first sheet and name it "Start" (no
quotes), and another blank sheet after the last sheet and name it "End" (no
quotes), and then enter this formula on the "Master" sheet:

=SUM(Start:End!A1)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"guilbj2" wrote in
message ...

=SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon,
Carrie'!C4:C35)+SUMPRODUCT('Deacon, Carrie'!B4:B35,'Deacon,
Carrie'!D4:D35)+SUMPRODUCT('Deacon, Carrie'!E4:E35,'Deacon,
Carrie'!F4:F35)

I'm using the formula above to calculate some stats for a call center.
On a master "group summary page", I need to get the sum of the results
of this formula from 20 worksheets. Other than duplicating the formula
and changing the names, is there a faster way to do this? The cell
references are identical for all, worksheets just the names change.

The only thing I can think of is "(formula using name 1) + (formula
using name 2)..." and so on for every sheet in the book. This will be
incredibly long and it seems to me there has to be a better way. Any
ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile:
http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=466391