May 01 2019 09:40 AM
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.
Could you please explain to me where does the variance come from knowing that the cell J2 there is only a text ("total")?
Thank you and best regards,
May 01 2019 09:50 AM
@Aureanne , second formula returns correct result. With first formula SUMIF shifts on one cell up with cells to sum. For example, if you have A in J5 and J7, SUMIFS returns K4+K6 in first case and K5+K7 for the correct formula.
May 01 2019 09:54 AM
@Aureanne , other words it finds positions of the cells which meet criteria in criteria range and sum cells on the same positions starting from the beginning of the sum range.
May 01 2019 10:42 AM
May 01 2019 10:58 AM
@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.
May 01 2019 11:36 AM
May 01 2019 12:01 PM
https://support.office.com/en-gb/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
As an example, this one works
May 01 2019 12:14 PM