Bill,

I just got a chance to try your suggestion out and I must thank you for it.
It's exactly what I need and I had no chance of ever figuring that out for
myself.

thank you.

DL

"Wild Bill" wrote in message
...
At the bottom of Column C take an average of total sales. In Column D
IF(C1 $C$13, "Above Average", "")
Drag and drop your formula, ($C$13) would be the cell you took the
average in.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!