Mar 31 2021 01:04 AM
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.
Mar 31 2021 02:21 AM
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) )
Mar 31 2021 03:37 AM