I would like help using a formula to check for a constant item in a status
column (i.e. "Open" or "Closed") and a unique variable in another # column of
duplicate entries (i.e. 1,1,1,2,2,3,3,3,3,...). The numbers represent the
session a person attended. Desired result is to count the number of Open,
Closed, & Pending sessions. Formula(s) should return Open=3; Closed=2;
Pending=1.
I am using Excel 2003. Thank You Very Much.
# Name Status
1 John Smith Open
1 Jane Doe Open
1 Jack Fox Open
2 Jeff Mann Closed
2 Tony Tee Closed
3 Lee Jones Open
4 Mary Clay Closed
4 Sue Sun Closed
5 May Fine Pending
5 Lou Ides Pending