Conditional Sum w/o using the Wizard.

R

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

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.
Click to expand...
 
Top