hi,

i have this table which compiles all ours monthly sold contracts. basically i want a function to look at the salesman in one column and add the value of that contracts (and then repeat so it totals all the indivdual salesmans total monthy sales). how could i do this with using a separate if function on every line for each different salesman?

thanks