Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Records Between A-K and L-Z
I have a spreadsheet used to track claims. Case Managers are assigned the
cases based on the surname of the client. For instance, Jane case manages all clients with a surname between A and K and Jill manages all clients with a surname between L and Z. I would like to set up a formula to count the number of cases each case manager has. Can this be done with a wildcard? I have been fighting with this trying to find the answer, which I'm sure is simple. Any assistance you can provide is greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Records Between A-K and L-Z
Leslie,
For A-K use =COUNTIF(A1:A10,"<k") For L-Z, use =COUNTIF(A1:A10,"<=z")-COUNTIF(A1:A10,"<=l") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Leslie" wrote in message ... I have a spreadsheet used to track claims. Case Managers are assigned the cases based on the surname of the client. For instance, Jane case manages all clients with a surname between A and K and Jill manages all clients with a surname between L and Z. I would like to set up a formula to count the number of cases each case manager has. Can this be done with a wildcard? I have been fighting with this trying to find the answer, which I'm sure is simple. Any assistance you can provide is greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Records Between A-K and L-Z
=SUMPRODUCT(--(UPPER(LEFT($A$2:$A$200,1))="A"),--(UPPER(LEFT($A$2:$A$200,1)
)<="J")) etc. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Leslie" wrote in message ... I have a spreadsheet used to track claims. Case Managers are assigned the cases based on the surname of the client. For instance, Jane case manages all clients with a surname between A and K and Jill manages all clients with a surname between L and Z. I would like to set up a formula to count the number of cases each case manager has. Can this be done with a wildcard? I have been fighting with this trying to find the answer, which I'm sure is simple. Any assistance you can provide is greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Records Between A-K and L-Z
Thank you Chip - you saved me a lot of time!
"Chip Pearson" wrote: Leslie, For A-K use =COUNTIF(A1:A10,"<k") For L-Z, use =COUNTIF(A1:A10,"<=z")-COUNTIF(A1:A10,"<=l") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Leslie" wrote in message ... I have a spreadsheet used to track claims. Case Managers are assigned the cases based on the surname of the client. For instance, Jane case manages all clients with a surname between A and K and Jill manages all clients with a surname between L and Z. I would like to set up a formula to count the number of cases each case manager has. Can this be done with a wildcard? I have been fighting with this trying to find the answer, which I'm sure is simple. Any assistance you can provide is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count records in a date range | Excel Discussion (Misc queries) | |||
count duplicate records in a group | Excel Worksheet Functions | |||
How can the count of filtered records always display? | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Filter Count of Records Retrieved. | Excel Discussion (Misc queries) |