Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct accross multiple sheets
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple sheets | Excel Worksheet Functions | |||
Printing Multiple sheets | Excel Discussion (Misc queries) | |||
sumproduct from multiple sheets | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) |