Referring to my previously posted formula for [your criteria for A]
etc.
you would use an AND function which works like this:

AND(criteria1,criteria2)

so if you wanted to classify it as "B" the function would be:

AND(A11,A1<5)

and for C:

AND(A15,A1<10)

where A1 is your account.

Note that B is less than 5 and C is greater than 5, it will not
recognize any
account that is exactly 5 so you should use <= or = depending on your

situation.

Let me know if you need anything else.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510165