Forum Discussion
help me on SUMIF or IF Multiple formula i.e. attached with this post.
I have a problem when playing with SUMIF or IF, I want to get the result from Multiple cells. Please have a look on it, and give me a chance to thank you.
The solution varies slightly according to the version of Excel that you are using.
= SUM( IF(Score<Max, Score, Max) )
works as it is in Excel 365 but other versions need CSE or SUMPRODUCT to obtain array behaviour.
365 would also allow more explanation in the form
= LET(
cappedScore, IF(Score<Max, Score, Max),
SUM(cappedScore) )
Thank you dear peter.