Count with 1 variable & 1 constant criteria formula

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
 
E

Excel-User-RR

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

Gary Brown

Take a look at the CountIf function. I think that's what you're looking for.
 
E

Excel-User-RR

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
:

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top