View original (French)

SUMIF formula if another cell has "YES"

Solved
Dilisk -  
 Dilisk -
Hello,

I want to know how to trigger the calculation of a formula in the range (A1:A8), for example, only if the word "YES" is in my cell B4

Does anyone have the solution?

Thank you for your replies.

Configuration: Windows 7 / Chrome 31.0.1650.63

3 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    try with:
    =if(B4="yes",sum(A1:A8),"")

    eric

    --
    In addition to the thank you (yes, it can be done!!!), remember to mark it as resolved when it's the case (at the top near your title).
    Thank you
    0