Countif help needed
Help Please!!!
I have 2 colums, one which shows sales people the other which shows Dollar amount. Can I formulate a cell to ask wherever you see Sales Person A then copy the adjecent cell throughout a range or column? |
Will "Sales Person A" be entered more then once in the column?
If so, would you want *individual* displays of each dollar amount occurrence, or would you like a single, *total*, dollar amount for the salesperson? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "tamato43" wrote in message ... Help Please!!! I have 2 colums, one which shows sales people the other which shows Dollar amount. Can I formulate a cell to ask wherever you see Sales Person A then copy the adjecent cell throughout a range or column? |
tamato43,
I am not sure if this is what you are asking for, but I would do it by using Advanced Filter. Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "tamato43" wrote in message ... Help Please!!! I have 2 colums, one which shows sales people the other which shows Dollar amount. Can I formulate a cell to ask wherever you see Sales Person A then copy the adjecent cell throughout a range or column? |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com