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 réponses

eriiic Posted messages 24581 Registration date   Status Contributeur 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