Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage when total sales is a credit | Excel Discussion (Misc queries) | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
backing sales tax out of a total including sales tax | Excel Worksheet Functions | |||
How to sum total automatically in more than one sales invoices | Excel Worksheet Functions |