Countif help needed

T

tamato43

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?
 
R

RagDyeR

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 !
--------------------------------------------------------------------

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?
 
S

Sandy Mann

tamato43,

I am not sure if this is what you are asking for, but I would do it by using
Advanced Filter.

Regards

Sandy
 
Top