# Resolved: Where is the Wrong here?

Could you please advise where is the wrong in the written function as it the same as the correct solution but when i use it, it return **with Zero not 39.37?**

Thanks in Advance

Hello,

The screenshot, which you've shared doesn't allow me to see column E. Probably Excel didn't recognize one of your criteria and this is why the result of the function is 0. I need to see columns E and W to be able to tell you the mistake.

Best,

Ned

This is the full picture of the columns related to the function

If we manually filtered the requested criteria it shown that no **ads revenue** related to "**EVERGREENSALE20"** code

and the result **39.87** related only to the total revenue of "**PROMO15** code as per the below

Oh right. And the sum of the two is 0 + 39.87 = 39.87. Correct?

Yes, Correct but how we can apply this with one formula to get the correct result of 39.87?

You can obtain the answer for both rows and then sum the two answers. Does that work?

let me clarify my understanding:

we can't use the same criteria range twice for Sumifs function, so we use Sumifs for two times first one for **EVERGREENSALE20** and the second for **PROMO15** then we sum the two answers

Am i correct?

You can actually use just SUMIF in this case I think.

Best,

Ned

```
```