Forum Discussion

Titchard Family's avatar
Titchard Family
Copper Contributor
Nov 30, 2017
Solved

Add 5 if a cell contains text "yes"

Hi all   Is this possible?. I would like to add several cells together then add "5" to the total if one cell contains the text 'yes'.   I have so far   =SUM(B1,C1,D1,E1)   please help...
counting cells if
Formulas & Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Nov 30, 2017

    Hi,

     

    Yes, this is possible!

     

    Try this formula:

     

    =IF(SUM(IFERROR(SEARCH("yes",B1:B10),0))>0,SUM(B1:B10)+5,SUM(B1:B10))

    NOTE: To enter this formula press Ctrl+Shift+Enter, this keystroke will force the formula to return the right result.

     

     

Hitesh Gaur's avatar
Hitesh Gaur
Copper Contributor
Jun 13, 2018

Hi,

Is this what you wanted?

Rgds.

Hitesh Gaur

Resources