Can a SUMPRODUCT array formula be used across multiple worksheets?

R

Ray

Hi -

I have a workbook with 32 worksheets (Summary and 1-31) ... all sheets
are formatted the same way, with names in column A and then data-
values in B:L. The list of names on the Summary Sheet is all-
inclusive; however, these names may or may not appear on sheets 1-31.

Of course, the Summary should add up the values (per name) on sheets
1-31, and handle the fact that a) the name may not exist on a specific
sheet, and b) that the value on the sheet may be an error (#N/A).

Here's what I have so far, which doesn't work:
=SUM(IF(ISNUMBER(VLOOKUP($A28,'1:31'!$A$27:$L$395,3,FALSE)),
0,VLOOKUP($A28,'1:31'!$A$27:$L$395,3,FALSE)))

How can this formula be modified to sum appropriately? or, is there
another formula that would work better?

TIA<
ray
 

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