Multiple Cell Foruma with FIND & ADD

Hey All,

I have figured out =IF(ISNUMBER(FIND("SS",B11)),"7","") which if SS is placed in B11 it will update the cell with a 7.

I need to do the following:

=IF(ISNUMBER(FIND("SS",B11,C11,D11,E11)),"7","") then keep adding up the 7's for any cell that it checks for.

So if there is a SS in B11, D11 and E11 the total in the CELL becomes 21 as an example.


Thank you to anyone who can help. Cheers!

Rick

Try
=COUNTIF(B11:E11,"*SS*")*7

You guys are amazing, thank you so much, is it possible to use the same forumla but instead of a 0 value being shown have it blank until a value is added?

Thank you again!

Originally Posted by Glenn Kennedy

or (since you have Excel 2003), you will have to use:

=IF(ISERROR(1/(1/(COUNTIF(B11:E11,"*SS*")*7))),"",COUNTIF(B11:E11,"*SS*")*7)

If you're going to brute force it for 2003 compatibility, might as well just do

=IF(COUNTIF(B11:E11,"*SS*"),COUNTIF(B11:E11,"*SS*")*7,"")

Im perfectly OK with brute force... Your effort IS prettier, though !!

haha I just realized it says 2003 excel still, I am on 2011 and the first formulas work perfect.

Thank you Glenn, I appreciate it.

One last question ( so sorry ). Is there a way to tell it to ignore the error of checking an empty cell?

Thank you again.

Excel gives the error ( with the green arrow ) showing that it is checking an empty cell, was wondering if there was a way for it to ignore the check error on an empty cell.

Cheers!