Conditional Sum w/o using the Wizard.

[ron]

When I use this formula, I get a #VALUE error.

=SUM(IF(I9:I17="aaa",K9:K17,0))

I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells
K9 thru K17 for each occurance of "aaa" in cells I9 thru I17.

 

[Dave Peterson]

How about =sumif()

=sumif(i9:i17,"aaa",k9:k17)

When I use this formula, I get a #VALUE error.

=SUM(IF(I9:I17="aaa",K9:K17,0))

I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells
K9 thru K17 for each occurance of "aaa" in cells I9 thru I17.

 

[Teethless mama]

=SUM(IF(I9:I17="aaa",K9:K17))

press ctrl+shift+enter, not just enter

 

[ron]

What a simple thing. Thanks to you both.