Hello,
I have a problem which I can't figure out. I tried to sumproduct, but I am new to it and can't get it done. So hopefully one can help.
Problem:
I have vendor bonusses based on a tier based on numbers sold, with different percentages. This sold units cumulate over the years so, the tier where they are in doesn't start with a recount each year.
There are some co-vendors who both get a bonus based on the same item, yet the agreements can differ.
In made an example for 3 articles in 10 rows. The actual would be around 350 articles with 800/900 rows. In column K I manually calculated the expected result, but for that many rows it would be very timeconsuming and I need to do this every year.
Bookmarks