Forum Discussion
Formula SUMIF - mistake
Hi, I used the formula SUMIF and found a mistake on my formula. =SUMIF(K3:K371;"A";J2:J371) instead of =SUMIF(K3:K371;"A";J3:J371). After corrected the formula, I had a different total amount. ...
Twifoo , SUMIF doesn't require what ranges have to be the same size, they could be different. Another story is what as a rule better to use same size ranges.
Excel insists, and so requires, both range and sum_range arguments to be equal. In the SUMIF syntax, just like law, the word “require” should be construed according to its spirit that gives life to, rather than according to its literal sense that kills, its true meaning.
https://support.office.com/en-gb/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
As an example, this one works
- That’s exactly my emphasis earlier. I construed the word “require” according to its spirit that gives life to its true meaning. Apparently, you construed it according to its literal sense. I won’t insist how you construe it. That’s your prerogative and I respect it, although I won’t necessarily conform thereto.