Need some help with a counting function
Hello,
I use a simple sheet to organize the timetable of my patients. Now I'd like to count how many different patients I attend, without counting a patient twice if I attend him twice a week for example. My sheet looks like this:
Mon | Tue | Wed | Thu |
---|---|---|---|
John | Steve | John | Wesley |
Mary | Harry | Deborah | |
Peter | Arnold | Carol | |
Chris | Mary | Sarah | |
Karen | Karen | ||
Carol | Larry | Peter |
So the answer would be 13, because I attend 13 different patients a week. Fields in blank should no be counted, the cell contend changes frequently.
A friend of mine tried to help me with a countif function but it didn't work out for me, it would count the fields left blank too.
Any idea?
Thanks, gabriel