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.