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

%3CLINGO-SUB%20id%3D%22lingo-sub-2246501%22%20slang%3D%22en-US%22%3Ehelp%20me%20on%20SUMIF%20or%20IF%20Multiple%20formula%20i.e.%20attached%20with%20this%20post.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246501%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20when%20playing%20with%20SUMIF%20or%20IF%2C%3C%2FP%3E%3CP%3EI%20want%20to%20get%20the%20result%20from%20Multiple%20cells.%3C%2FP%3E%3CP%3EPlease%20have%20a%20look%20on%20it%2C%20and%20give%20me%20a%20chance%20to%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2246501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@AyubBijapur 

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