Counting a text and numbers

[DenniBrink]

Hello everyone! I am challenged to write an Excel formula that will conditionally count a combination of text and number values. The best that I can do is to pearl string a long list of Countif formulas. For example:

Countif(E12:E32,"3") + Countif(E12:E32,"OT")

I wonder if there is a better way.

I believe the task is to have the IF statement list of Trues and Falses converted to Ones and Zeros and then SUM the total of Ones. I haven't figure out how to properly nest the IF and SUM functions. Can anyone help?

 

[AhoyNC]

Maybe like this:

Excel Workbook
	E	F	G
11
12	AA		6
13	OT
14	3
15	6
16	RE
17	OT
18	3
19	RE
20	3
21	OT
22
Sheet

 

[mikerickson]

Perhaps

Unknown
	A	B	C	D	E
1	Apple		OT		4
2	Banana		3
3	OT
4	3
5	5
6	OT
7	cat
8	3
9	3 goats
10	fish
Sheet1

Cell Formulas
Range	Formula
E1	=SUMPRODUCT(COUNTIF(A1:A10,C1:C2))

 

[DenniBrink]

Works beautifully! Awesome to learn something new. Thank you for the gift of knowledge. All the best, Dennis