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