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.

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.

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.

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.