Formula: If a cell has "text", add the value from an adjacent cell to the total

**ollyr** · 05-25-2016, 09:19 AM

Hi all,
I am trying to set up a formula that adds a number to a total if the cell alongside it has some specific free text.

Value	Text
10	No
14	Yes
16	Yes
20	No

Total: 30

I am trying to get the total to be automatically calculated if the text is "yes". If it says anything else, don't add the adjacent number to the total.

How could I achieve this with a formula?

Thanks in advance!

**Tony Valko** · 05-25-2016, 09:22 AM

Try this...

=SUMIF(B2:B5,"Yes",A2:A5)

**ollyr** · 05-25-2016, 09:52 AM

Result! Thanks

**Tony Valko** · 05-25-2016, 10:37 AM

You're welcome. Thanks for the feedback!

Formula: If a cell has "text", add the value from an adjacent cell to the total

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Formula: If a cell has "text", add the value from an adjacent cell to the total

Re: Formula: If a cell has "text", add the value from an adjacent cell to the total

Re: Formula: If a cell has "text", add the value from an adjacent cell to the total

Re: Formula: If a cell has "text", add the value from an adjacent cell to the total

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If total cell equals 0 add the text "N/A"

Macro which searches for cell with text "Total Cost" and references cell 3 to the right

Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell

Set value of cell if text in adjacent cell is "Bold"

[SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"

Find all cells with "A" and add the values of the adjacent cell to give a total.

Bookmarks

Bookmarks

Posting Permissions