Smonczka:

Are the reports sent to you on a spreedsheet with
the reps in columns or are they all lumped together.
If they are in spreedsheet form one name one cell
a solution is pretty strightforward if not you will
need to treat it as a string and search the string for
occurrances of the differant names.

Good Luck
TK


"Smonczka" wrote:

TK they do not split the commission. All are paid commission on the
total 300. so if there are four persons on a $300 all four would
receave commisson for the full 300.

David thanks I will look up the SumIF fuction. Thanks.

Steve