software

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

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

please help me if at all possible. thank youIn excel, there's an =sumif() function.

=sumif(a9:a900,1,o9900)

I don't know if that exists in Works, though.
Gary wrote:
gt;
gt; What I am trying to do is, from row 9 thru 900 find all values in column
gt; quot;Aquot; that are equal to 1 or 1.5, and in those rows sum the values of column
gt; quot;Oquot; and put this total in cell A3.
gt;
gt; This is what I have tried unsuccessfully =vlookup(quot;1quot;,A9:A900,sum(O9:O900)
gt;
gt; please help me if at all possible. thank you

--

Dave Peterson