help me on SUMIF or IF Multiple formula i.e. attached with this post.

New Contributor

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.

2 Replies


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) )