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 , 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.
SergeiBaklan Thanks a lot!
Aureanne , you are welcome