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

[fitful_thought]

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

 

[Wild Bill]

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.

 

[fitful_thought]

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