countif function
 

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???

countif function
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"hannatrip" wrote in message
...
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???