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

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

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?

Follow this topic

Muhammad Hanafy

Last answered:

01 Oct 2022

Posted on:

30 Sept 2022

Resolved: Where is the Wrong here?

in Introduction to Excel / Key Excel Functions: Sum, Sumif, Sumifs

7 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

30 Sept 2022

Muhammad Hanafy

Posted on:

30 Sept 2022

Ned Krastev

Instructor

Posted on:

30 Sept 2022

Muhammad Hanafy

Posted on:

30 Sept 2022

Ned Krastev

Instructor

Posted on:

01 Oct 2022

Muhammad Hanafy

Posted on:

01 Oct 2022

Ned Krastev

Instructor

Posted on:

01 Oct 2022

Helpful answer

Resolved: Where is the Wrong here?

Submit an answer

related questions