|
|
|
|
#1
05-10-2018, 10:40 AM
|
|||
|
|||
I currently am getting the attached error message for the below formula:
=sumproduct(SUMIF(Indirect("[Example A.xlsx]Schedule!$U$13:$U$17&[Example B.xlsx]Schedule!$R$13:$R$17"),$B40,Indirect("[Example A.xlsx]Schedule!$V$13:$V$17&[Example B.xlsx]Schedule!$S$13:$S$17))) Thoughts? 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sumif with multiple sum range
|
Haha88 | Excel | 6 | 10-29-2015 03:26 AM |
|
SUMIF not working across multiple columns
|
SteveBump | Excel | 3 | 05-14-2015 07:06 AM |
|
SUMIF/SUMPRODUCT across multiple sheets/Criterias
|
lukeyb_11 | Excel | 1 | 02-14-2014 10:30 AM |
| Outlook 2010 - Multiple Address Books Imported from 2007 Visible but Not Accessible | BradTinBC | Outlook | 1 | 04-10-2012 10:17 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows 7 64bit 
Office 2016
Hybrid Mode