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