Counting A Calculated Cell

[dallr]

Hey Guys,

I have a calculated cell in excel using and if function. e.g if(A2<50, "Poor","Good") across many rows of data. How and want to use a countif function to get the total count of the Poor and Good. But it seems like excel countif function does not count data that is returned from an IF function. Can someone tell me a way to count this data without using a pivot table?

Thanks for your feedback in advance.

Dallr

 

[JoeMo]

Excel Workbook
	A	B	C	D	E
1	Data	Formula		Good Count	Poor Count
2	-39	Poor		4	15
3	-97	Poor
4	18	Poor
5	-38	Poor
6	18	Poor
7	28	Poor
8	-88	Poor
9	21	Poor
10	-29	Poor
11	60	Good
12	12	Poor
13	67	Good
14	51	Good
15	-76	Poor
16	-41	Poor
17	-15	Poor
18	-29	Poor
19	-74	Poor
20	93	Good
Sheet3

 

[dallr]

This worked, thank you so much!!

Appreciate the help!

 

[JoeMo]

This worked, thank you so much!!

Appreciate the help!

You are welcome - thanks for the reply.