Sumproduct across multiple worksheets

P

Paul

I have a collection of worksheets, each with the same format of report, and a
summary sheet which shows the name of each worksheet.

I want to create a selection sheet, where I can mark each of the required
sheets and have the selection sheet show the summed data.

I have tried :
=sumproduct(SheetA:SheetZ!C10,SheetA:SheetZ!$A$1), but it returns a #REF error
(A1 in each sheet holds a 1 if the sheet is required to be included.)
(C10, plus a number of other cells, holds the relevant data on each worksheet)

Any help would be appreciated
 
L

Luke M

Sadly, SUMPRODUCT does not support 3D referencing. You can quickly do a
search in XL help file to find what formulas do.

Sorry I wasn't more helpful.
 
T

T. Valko

C10, plus a number of other cells, holds
the relevant data on each worksheet
Click to expand...

Specifically Define: "plus a number of other cells".

Are the cells in question in a contiguous range?
 

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

Similar Threads

SUMPRODUCT - Multiple Criteria 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
SUMPRODUCT across several sheets 5
COUNT rows on external sheet if between date range 3
Stumped - multiple lookup criteria across worksheets 3
summary values across worksheets within the same workbook 2
Sumproduct across worksheets 3
sumproduct from multiple sheets 3

Top