Count Formula

M

Mat

Hi,
Help Required

I have 400 clients listed in Column A and Column F has 4 options for each
client. The colums A and F are as follows;

Column A Column F
Supplier 1 Good
Supplier 2 Neutal
Supplier 3 Fair
Supplier 4 No relationship
Supplier 5 Fair
Supplier 6 Good

My Question;

I need a formula which can give total count of Good, Neutral, Fair and No
relationship in cell F 23.
Regards
 
M

Mike H

Hi,

Try this

=COUNTIF(F1:F20,"Good")

with the obvious change for the other categories.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top