MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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