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.

     

     

John Jairo Vergara Domínguez's avatar
John Jairo Vergara Domínguez
Brass Contributor
May 24, 2018

Hi, to all!

 

You can use this formula (non CSE formula):

=SUM(B1:B10,5*COUNTIFS(B1:B10,"?*",B1:B10,"<>No"))

 

Blessings!

Resources