countif function

G

Guest

I have a spreadsheet that has a drop down list with 5 names in it, on another
sheet I want to do statistics and in a15 on the statistics sheet I want to
count how many in the column the drop down list is no matter whose name it on
it. do i make sense???
 
B

Bernard Liengme

=COUNTIF(Sheet1!A1:A2,"Hanna")
or
in A1 enter Hanna
=COUNTIF(Sheet1!A1:A2,A1)
 

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

Similar Threads

List of items from other sheets 2
Interrogating Data on Hidden Sheets 1
Alt codes 4
Data Validation List problem 5
Dependent drop down dynamic range formula, off sheet. 7
Clear a "moving" range offset from Target 31
COUNTIF calculations & Two-way Lookup 2
Excel Excel: How do I put a formula in a drop down list 11

Top