I tried a lot of ways, but it seems that nothing works. As I said that I work
in a school, the problem is that I don't know the name of the student who is
coming next week to me, so I have to have a function that allows me to use
mulitible names or a joker.
I tried with IF but it doesn't work. What shall I use???
--
Moualla


"SteveG" skrev:


Moualla,

Assuming that the Name is in A1 and the range to count is A2:A15 then

=IF(A1="Your Name",COUNT(A2:A15),"")

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504456