# Sumifs double nested condictional

1. ## Sumifs double nested condictional

Here is my Formula...

=IFERROR(SUMIFS(SGReport!E:E,SGReport!L:L=[@[Product List]],SGReport!K:K=ArrayData!E5),TRUE),"Didn't Work")

is not working but it seems correct. I am looking to Sum if you find the condiction is true

If colu L:L matches @ Prodcut list and if in colum K:K matches E5 then add the numbers in colum E:E

~J  Register To Reply

2. ## Re: Sumifs double nested condictional

IFERROR only has 2 parts, The formula to test for error, and the result you want if it is an error.
If it is NOT an error, it just executes the original formula

=IFERROR(calculation,valueiferror)

You're trying to do
=IFERROR(sumif,true,"didn't work") <--3 parts

Try
=IFERROR(SUMIFS(SGReport!E:E,SGReport!L:L=[@[Product List]],SGReport!K:K=ArrayData!E5),"Didn't Work")

This will return "Didn't work" if the sumifs results in an error, otherwise it just gives the result of the sumifs.  Register To Reply

3. ## Re: Sumifs double nested condictional

I try that ...it just says't that it dosen't work... Excel says the formula is wrong...

=IFERROR(SUMIFS(SGReport!E:E,SGReport!L:L=[@[Product List]],SGReport!K:K=ArrayData!E5),"Didn't Work")  Register To Reply

4. ## Re: Sumifs double nested condictional

Ah, I see it now...
In sumif(s), the syntax for criteria isn't range=value, it's range,value (one argument for the range, next argument for the criteria)

so try
=IFERROR(SUMIFS(SGReport!E:E,SGReport!L:L,[@[Product List]],SGReport!K:K,ArrayData!E5),"Didn't Work")  Register To Reply

5. ## Re: Sumifs double nested condictional

THX that worked   Register To Reply

6. ## Re: Sumifs double nested condictional

You're welcome.  Register To Reply