I have cell B7 and down the column with customer names. Cell C7 and down the
column will be the sales rep listed for the customer where some of the cells
for c7 will be blank. Cell d7 and down will be the sales number for that
customer. I have cell A1 to A6 with the sales reps names. I want to get the
total of sales for each rep in A1, A2, A3 and so from the customer data. One
of the reps will be getting the data will no info in c7 and down where the
others will correspond with the rep name.

Thank you