In A1:A5 I have the following values:
12 9 6 11 10
I am trying to write a formula to calculate the sum of A1:A5, but apply MAX(ref, 10) to each value before calculating the sum. The result should be 45, calculated as 10+9+6+10+10. Is this possible to somehow include an array with a MAX formula? Ideally I will not use helper columns.
Thank you.
Bookmarks