Counting data in a range

S

Stuart

I want to count a specific data item from a range e.g. say the data below was
in column A and B on a spreadsheet:

Department Name
SALES John
SALES Fred
IT Sue
FINANCE Stu
SALES Jo
HR Steve

I want to count the number of times SALES occurs. I've tried DCOUNT/DCOUNTA
but haven't got this to work. Any help appreciated!
 
S

Stuart

Thanks CLR, that did the trick.

Is there a function that will count ALL values in the range i.e.
SALES = 3
IT = 1
HR = 1
FINANCE = 1

Thanks.
 
C

CLR

You're welcome Stuart.............to count everything,

=COUNTA(A:A)

To count everything EXCEPT "sales"........

=COUNTA(A:A)-COUNTIF(A:A,"SALES")


Vaya con Dios,
Chuck, CABGx3
 

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