Words ... yay ... letters .... blech!

  • Thread starter Thread starter m4d Ir15h
  • Start date Start date
M

m4d Ir15h

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.
 
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.
 
Back
Top