Sum items in a row when items in other row meet certain criteria.
Posted by Steve on August 27, 2001 9:21 AM
Trying to figure out a way to sum items in a row when their corresponding row meets a certain criteria. ex..
Row 1 Row 2
10 aaa
10 aaa
10 bbb
in this case everytime aaa comes up in row 2 I want the corresponding value in Row 1 to be totaled..
Posted by Aladin Akyurek on August 27, 2001 9:28 AM
=SUMIF(B1:B10,"aaa",A1:A10)
Aladin
