when Boggs is on duty the total sales are higher than when he is absent
 

Hi,

I need to be able to show that when Bloggs is on duty the total sales are
higher than when he is absent.

Column A = mmyy.
Column B = Bloggs or nothing.
Column C = Total sales.

If anyone can help with this, I'd me most very grateful indeed.

DL

when Boggs is on duty the total sales are higher than when he is absent
 

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!

when Boggs is on duty the total sales are higher than when he is absent
 

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!