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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

m4d Ir15h - 07 Mar 2008 20:27 GMT

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 to this Message

Gary''s Student - 07 Mar 2008 20:31 GMT

=COUNTIF(C:C,"RXL")

Signature

Gary''s Student - gsnu200772

> Can someone help me find a formula to calculate a given number of words or
> letters in a specific column?
[quoted text clipped - 3 lines]
> 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 to this Message

m4d Ir15h - 07 Mar 2008 21:14 GMT

Is it possible to use that same code to check within specific dates?

> =COUNTIF(C:C,"RXL")
>
[quoted text clipped - 5 lines]
> > 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 to this Message

JMB - 07 Mar 2008 23:38 GMT

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.

> Is it possible to use that same code to check within specific dates?
>
[quoted text clipped - 7 lines]
> > > 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 to this Message

Rate this thread: