Add up values that contain certain words

Hi all,

I have tried looking through the forum and can't seem to find the answer I am looking for and need some assitance please.

I am creating a wedding sheet, on this sheet, I have cells B2:H11 that contains names of guest. I have a counta at the bottom to total all cells that contains names in there.
Some of the cells have initials of their parents name followed by Kid (A&A Kid).

What I am trying to do is add up all the ones which contains the word "Kid". I have lots of thinking of how to do it, I've tried to put it together but it is not creating what I want.

My first idea was to do an if statement with a right formula, then struggled with how to count, so I started to do the countif with the right formula, I've tried to do the countif,if and right formula and still couldn't put the puzzle togther. Im not sure if I am over complicating this.

Any help please.

Thank you

If you want to count number of cells where kids written, use below formula:

=COUNTIF(B2:H11,"*kid*")

you can use "*kid*" in sumif, sumifs formulas as well.

Originally Posted by excelfandoo

If you want to count number of cells where kids written, use below formula:

=COUNTIF(B2:H11,"*kid*")

you can use "*kid*" in sumif, sumifs formulas as well.

OMG that is soooo simple and perfect! Thank you soo much for your help

On another note, do you know where I could find information on where I can learn these hidden functions (I only knew about the " " function).

Thank you pasqui83.

I would suggest you follow this forum for some time and go thorugh solutions of problems posted here, to learn Excel.