Count with 1 variable & 1 constant criteria formula

  • Thread starter Thread starter Excel-User-RR
  • Start date Start date
E

Excel-User-RR

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
 
Correction. Sorry. I should have written Formula(s) should return Open=2;
Closed=2; > Pending=1. Thanks.
 
I apologize for my unclear posting. I have 2 conditions that I am trying to
satisfy. The Countif function will only count 1 criteria. I want to count the
number of unique sessions for each type of Status. There are 3 people in
session 1 (# col.) and the status is open (status col.), but I only want
count this open session once, each closed session once, and each pending
session once. Per my example to get:
Open=2; Closed=2; Pending=1 I do not want: Open=4, Closed=4, Pending=2.
Sorry for any confusion - I am a formula novice.
Gary Brown said:
Take a look at the CountIf function. I think that's what you're looking for.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
Click to expand...
:

Correction. Sorry. I should have written Formula(s) should return Open=2;
Closed=2; > Pending=1. Thanks.

:

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
 
Back
Top