How to Sum Values If a Cell Contains a Specific Text | SKYXCEL

Welcome to SKYXCEL Tips & Tricks! Today we will be showing you how to sum values if a cell contains a specific text. Additionally, we will reveal how to enhance the SUMIF function to create criteria that matches values beginning or ending with specific text.

Please give this video a like if you found this tutorial helpful and subscribe to receive updates for future tutorial videos that will save you time and increase your efficiency.

We invite you to leave any questions or request in the comments below!

In need of more Excel assistance specifically for you? Visit

[andrebuys]

Awesome! Precisely what I wanted to know. This was explained in a way that is very easy to understand. Thx a mil!

[jsfernald]

This is exactly what I needed! Thank you!!!

[ddp]

this video was great thank you. I finish my project.

[mudassar]

Thank you for keeping it clear and concise.

[lismar]

What if I'd like to do the sum of two specific words?

[syedhussain]

If we have morethan one colum then how it will work ? because with me just working one colum as you mentioned in the video .

[pm]

How can I do this formula to sum without a letter being in front of the numbers? Please help.

[markofilipovic]

Hi

Is possible to sum all WA11?

(A1) WA11 4

(A2) AdBlue 1, WA11 223

(A3) AdBlue 3, WA11 32, shift 4

... and everything is in one column.

[JunaidAli-vctu]

Hey mate! I need help.

I would like to create a name range for a particular "range of values". I tried to name them by "range of cells". It worked BUT when I tried to filter the table. The data changed.

What do I do - if I don't want the data to change when I filter. Let me know how to proceed. Thank you.

[YanKanaan]

what if i want to match the value of 2 cells and not just 1 cell?

[brcleaningcompany]

what if it contains time and cost in same cell but i only want to sum the currency in each cell on the column, , , example (A1) "bob 3:00 oclock $450" (A2) "julie 5 o clock $20" how do i sum only the cost? when the description and time and cost is all in one cell? any assistance would be greatly appreciated

[parthasarathybalasubramani]

WHAT IF THERE IS A MERGED CELL BETWEEN THE QUANTITY ROW AND YOU HAVE CONTINUE THE ADDITION? ANY OTHER TIP OR DO WE HAVE TO REPEAT THE SUMIF ?

[meranism]

Thank you for the information sir. I would like to see if there is a way to apply the same method for several columns? I have a sheet where I input my monthly expenses and I separated it by months. So each month has it's own expenses in different column. Is there a way to get a sum for a specific expense, let say (GAS)? I would really appreciate it if you could help me. Other wise the way I do it now I get a sum for each month and then add up all those numbers to get a sum of all. That's taking a long time to put the same equation for each month over and over again. =SUMIF(A3:A25, "*"&AI5&"*", B3:B25)+SUMIF(C3:C25, "*"&AI5&"*", D3:D25) - this is what I use. but I have to do it for 12 months. Is there a shortcut for achieving the same result?

[hammadraza]

Hi,
What if we have a table and we want the total of all the calls contain specific text in whole table, not only in a row?

[fosterchild]

Great video...I need help am trying to do something very very very simple but I can't seem to figure it out. I have two columns of data. One column A with sentences and one column B with numbers. All I want to do is use sumif() to search column A for a specific string and add the numbers in column B together every time it finds an instance of my specific string in column A. problem is that I can't figure out how to make it look for my string I want to search column A for the string want to find every instance of the word don't want to include the life of me I can't figure it out.

[abdulhamidalfani]

hi, im not sure why it wont work if this formula is inserted inside a long formula..

[WormholeVenue]

How can i add up a long row, but only add up the values that are formatted as dollars? I tried your formula with "*$*" to only pick cells with a dollar sign on them. That didn't work.

[zegheminam]

Can you help me?
HSPW-0000 this is employee number
P= Philippines & W= worker. Please tell me formula that I write employee ID and get its Nationality

[enriquevalencia]

LOL I'm just trying to see how many S1, S4, MCCS, MCG and S6 are in ONE singular column. Great video by they way but still lost.

[jhanolaer]

how to sum like this in one cell (10kg x 10mtrs)+ (2kg x 30mtrs) and the answer should like this (12kg x 40mtrs) 😊