I am trying to use a countif formula to count how many students a teacher has. here is the formula COUNTIF(fceteacher!C:C,E2) I am using a dropdown list to count how many students the teacher has.
I am trying to use a countif formula to count how many students a teacher has. here is the formula COUNTIF(fceteacher!C:C,E2) I am using a dropdown list to count how many students the teacher has.
Last edited by rmklzm; 07-26-2009 at 01:45 PM.
assuming name is in e2 that should work. but name must be same length spaces included
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
it gives me a value error
i got it to work, i spelled the workwheet ref wrong. it should have been fceteacher! but i put in the formula as fcetecher!. That created the error.
Thank you for your help!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks