I am new to this site, but the posts I have read seem helpful. Here's an issue that is driving crazy.
I am attempting to sum a column based on the occurrence of a value at least one time in 4 columns, but I don't want to compound the result.
Sample data.
client1 Client2 Client3 Client4 Revenue
a a c d 100
b a c d 200
b b a a 300
I would want to sum the revenue column such that when I lookup client a, the result value is 600 b/c it appears at least once on each row. The fact that client a appears in multiple columns on 2 of the rows does not mean that the revenue column for those rows should be counted twice. I can't seem to figure it out. Sumproduct seems to get me close, but not quite.
I am attempting to sum a column based on the occurrence of a value at least one time in 4 columns, but I don't want to compound the result.
Sample data.
client1 Client2 Client3 Client4 Revenue
a a c d 100
b a c d 200
b b a a 300
I would want to sum the revenue column such that when I lookup client a, the result value is 600 b/c it appears at least once on each row. The fact that client a appears in multiple columns on 2 of the rows does not mean that the revenue column for those rows should be counted twice. I can't seem to figure it out. Sumproduct seems to get me close, but not quite.