|
|
|
|
#1
01-14-2012, 01:23 PM
|
||||
|
||||
Hi
I don't think 3 D references work with SUMPRODUCT Maybe create a formula in the same cell in each sheet and add the results with the SUM function which allows for 3 D
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 form a database from multiple sheets
|
udea | Excel | 1 | 04-25-2011 02:34 AM |
|
macro to pull data from multiple files
|
psrs0810 | Excel | 2 | 10-25-2010 01:49 PM |
|
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
| Print Multiple Sheets Double-Sided | flambe99 | Excel | 1 | 03-12-2010 01:15 PM |
| Excel 2007 doesn't print color graphics on multiple sheets | mwoolf | Excel | 1 | 06-19-2009 02:34 AM |
Windows XP 
Office 2003
Hybrid Mode