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.
 
Is it possible to use that same code to check within specific dates?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Words and dates... 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel Sumproduct 0
Why are columns in some Excel files numbered instead of lettered? 1
Excel A CountIF question... I think 2
finding and summing case-sensitive text 6
counting the first letters or first 2 letters in strings 1
Can I combine 2 formulas? 8

Back
Top