"IF" addition question

[The Animal]

Hi
Maybe somebody can help.

I would like a formula that sums cells T3, Q3, N3 if the text "PP" is or "C" is found in the cell "A3" (I.E 200PP or 155C) but if "S" is found in "A3" then the value 45 is populated.

Thanks for any help
Stephen

 

[Logit]

.
https://exceljet.net/formula/if-cell-contains-this-or-that

 

[The Animal]

Thanks for your help Logit.
I have looked at link and still having issues
I have come up with below
=SUM(COUNT($C$3:$C$27,{"*S*","*PT*"}),V$3:V$27) which is supposed to sum the values from V3:V27 only if S or PT is found in C3:C27 and ignore any others but I keep getting incorrect answer which is above what actual should be?
Any help would be great
Stephen

 

[The Animal]

Ok I have now used =SUMIF($C$3:$C$27,"*S*",V$3:V$27) but I need to SumIF either S or PT is found in C3:C27 not just S
Any help would be great
Stephen

 

[Logit]

.
For the "PP" or "C" use this formula :

=IF(SUM(COUNTIF(A3:N3:Q3:T3,{"*PP*","*C*"})),"x","")

For the "S" in A3 use this formula :

=IF(SUM(COUNTIF(A3,{"*S*"})),"45","")

I believe you will need to use two separate cells for the above formulas. I do not believe you can create a formula to be used in one cell, that will track all the conditions you are seeking.

 

[The Animal]

Great thanks for your help

 

[jtakw]

Hi,

Based on your description in Post #3 and #4 , not #1 where you said if S then 45, let me know if you need changes:

Book1
	C	D	V
1	6
2
3	200P		1
4	23S45		2
5	155C		3
6	45PT88		4
Sheet18

Cell Formulas
Range	Formula
C1	=SUMPRODUCT(ISNUMBER(SEARCH({"*S*","*PT*"},$C$3:$C$27))*(V$3:V$27))

 

[jtakw]

.
For the "PP" or "C" use this formula :

[COLOR=#FF0000]=IF(SUM(COUNTIF(A3:N3:Q3:T3,{"*PP*","*C*"})),"x","")[/COLOR][/[COLOR=#FF0000][/COLOR]CODE]

For the "S" in A3 use this formula :  [CODE]=IF(SUM(COUNTIF(A3,{"*S*"})),"45","")

I believe you will need to use two separate cells for the above formulas. I do not believe you can create a formula to be used in one cell, that will track all the conditions you are seeking.

Hi,

Highlighted in red above, that doesn't SUM anything in Column V, it just places an "x" in the subject cell if PP or C is found.