In excel, there's an =sumif() function.

=sumif(a9:a900,1,o9:o900)

I don't know if that exists in Works, though.



Gary wrote:

What I am trying to do is, from row 9 thru 900 find all values in column
"A" that are equal to 1 or 1.5, and in those rows sum the values of column
"O" and put this total in cell A3.

This is what I have tried unsuccessfully =vlookup("1",A9:A900,sum(O9:O900)

please help me if at all possible. thank you

--

Dave Peterson