| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Words ... yay ... letters .... blech!
Can someone help me find a formula to calculate a given number of words or
letters in a specific column? I am trying to keep track of how many accounts were done by a specific employee without having to count them one by one. I figure if I can find a formula that will tell me that there are 35 RXL's in column C, it will make my job easier in the long run. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Words ... yay ... letters .... blech!
=COUNTIF(C:C,"RXL")
-- Gary''s Student - gsnu200772 "m4d Ir15h" wrote: Can someone help me find a formula to calculate a given number of words or letters in a specific column? I am trying to keep track of how many accounts were done by a specific employee without having to count them one by one. I figure if I can find a formula that will tell me that there are 35 RXL's in column C, it will make my job easier in the long run. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Words ... yay ... letters .... blech!
Is it possible to use that same code to check within specific dates?
"Gary''s Student" wrote: =COUNTIF(C:C,"RXL") -- Gary''s Student - gsnu200772 "m4d Ir15h" wrote: Can someone help me find a formula to calculate a given number of words or letters in a specific column? I am trying to keep track of how many accounts were done by a specific employee without having to count them one by one. I figure if I can find a formula that will tell me that there are 35 RXL's in column C, it will make my job easier in the long run. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Words ... yay ... letters .... blech!
Lets say column B contains dates, C contains employee ID's (such as RXL) and
your criteria is in A1:A3, where A1 = RXL A2 = Begin Date A3 = End Date =Sumproduct(--(C1:C10=A1), --(B1:B10=A2), --(B1:B10<=A3)) modify ranges to suit. Sumproduct cannot accomodate an entire column (such as C:C) prior to XL2007. Also, I am assuming the dates are inclusive. "m4d Ir15h" wrote: Is it possible to use that same code to check within specific dates? "Gary''s Student" wrote: =COUNTIF(C:C,"RXL") -- Gary''s Student - gsnu200772 "m4d Ir15h" wrote: Can someone help me find a formula to calculate a given number of words or letters in a specific column? I am trying to keep track of how many accounts were done by a specific employee without having to count them one by one. I figure if I can find a formula that will tell me that there are 35 RXL's in column C, it will make my job easier in the long run. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change the letters in the top row to words | New Users to Excel | |||
| Need to scramble letters in list of words | Excel Discussion (Misc queries) | |||
| I have pound marks in a cell rather than words/letters. | Excel Discussion (Misc queries) | |||
| How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
| sorting letters in words into alphabetical order | Excel Discussion (Misc queries) | |||
![m4d Ir15h[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
