I am looking to do a sumif (I think it should be a Sumif).
See the attached example. Basically I want to sum in a formula a list of numbers, however, if the numbers are greater than the keys max number I want it to take the max number.
So in my example the max value of A is 3, so a value of 4 should be treated as a 3. In my example column J is how I want the numbers to be treated. I'd like to avoid duplicating the table and just have it do these calculations in the formula.
Bookmarks