Conditional Sum w/o using the Wizard.
 

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.

Conditional Sum w/o using the Wizard.
 

How about =sumif()

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

ron wrote:

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

Conditional Sum w/o using the Wizard.
 

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

press ctrl+shift+enter, not just enter


"ron" wrote:

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.

Conditional Sum w/o using the Wizard.
 

What a simple thing. Thanks to you both.

"ron" wrote:

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.