Check what specific text is contained in cells, then sum numbers contained in those cell

**Alco** · 09-13-2022, 05:01 AM

Hey guys

So I've been looking and searching for anything that could help me, to no avail.

I have columns of text and number combinations. I need excel to check a whole column to see if it contains "FT" in the text, if yes then find the number next to the text and sum it at the bottom.
This is the desired result:

Column A | Column B
FT4
FT2
FT4
SD4
SD3

10 | FT sum
7 | SD sum

Any help would be greatly appreciated

-Alco

**samba_ravi** · 09-13-2022, 05:35 AM

please attach a sample excel file

**Alco** · 09-13-2022, 05:51 AM

example.xlsx

Here you go!

**hasan mougharbel** · 09-13-2022, 06:47 AM

please check my solution,
I hope this helps..

**samba_ravi** · 09-13-2022, 06:56 AM

Try below array formula
=SUM(IFERROR(SUBSTITUTE(B4:B8,"FT","")+0,0))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

**Alco** · 09-13-2022, 08:27 AM

That works! Thank you so much!

-Alco

**Alco** · 09-13-2022, 08:27 AM

This does the trick too, you guys are very talented! Thank you :D

-Alco

Check what specific text is contained in cells, then sum numbers contained in those cell

LinkBack

Thread Tools

Rate This Thread

Display

Check what specific text is contained in cells, then sum numbers contained in those cell

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Re: Check what specific text is contained in cells, then sum numbers contained in those ce

Thread Information

Users Browsing this Thread

Similar Threads

How to check if numbers contained in a cell are also in another cell (or a better method)

[SOLVED] Check if a cell value is contained between two bounding cells

[SOLVED] How to count cells having text contained in a given cell?

[SOLVED] Search for the first cell that contained a specific text

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

[SOLVED] Can not figure out how to color cells based on the text contained in the cell

[VBA] Check if an integer is contained in a range of cells in a worksheet

Bookmarks

Bookmarks

Posting Permissions