Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with 1 variable & 1 constant criteria formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with 1 variable & 1 constant criteria formula
Correction. Sorry. I should have written Formula(s) should return Open=2;
Closed=2; Pending=1. Thanks. "Excel-User-RR" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with 1 variable & 1 constant criteria formula
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 "Excel-User-RR" wrote: Correction. Sorry. I should have written Formula(s) should return Open=2; Closed=2; Pending=1. Thanks. "Excel-User-RR" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with 1 variable & 1 constant criteria formula
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" wrote: 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 "Excel-User-RR" wrote: Correction. Sorry. I should have written Formula(s) should return Open=2; Closed=2; Pending=1. Thanks. "Excel-User-RR" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula - count NÂș of entries but with other filtering criteria | New Users to Excel | |||
subtract a variable no. of mos. from a constant date? in excel | Excel Discussion (Misc queries) | |||
Stopping a constant variable cell from being copied. | New Users to Excel | |||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
Variable criteria formula | Excel Worksheet Functions |