SUMIF with multiple criteria

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I am trying to develop a formula that will pull balances
based on a certain location, expense, and month, but I am
having problems. Here is what i have so far - please help!

SUMIF('Sorted Data'!B1:B1000=Table!A6,if(Table!
C1:C1000=Table!A9,if('Sorted Data'!Q1:Q1000=Table!
D4,'Sorted Data'!E1:E1000)))

thanks,
Matt
 
One way:

=SUMPRODUCT(--('Sorted Data'!B1:B1000=Table!A6),
--(Table!C1:C1000=Table!A9),--('Sorted
Data'!Q1:Q1000=Table!D3),('Sorted Data'!E1:E1000))

Though I wonder if you really mean

'Sorted Data'!C1:C1000=Table!A9

instead...
 
Still no luck...

Here is what I put in - it yielded #VALUE

=SUMPRODUCT(('Sorted Data'!$B$1:$B$1000=Table!$A$6)*
('Sorted Data'!$C$1:$C$1000=$A$7)*('Sorted Data'!
$Q$1:$Q$1000=Table!$D$5)*'Sorted Data'!E1:E1000)
 
Did you mean for $A$7 to reference the active sheet rather than
Table!$A$7?

Your formula worked for me in a test book. Make sure there are no
#VALUE! errors in your data (the error gets passed through the
function).
 
Bernard,
I couldn't get the formula to work for days...then i found
one small error in one of my data fields, and it solved
all of my problems...thanks for your help!
matt
 
Back
Top