ms works question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In excel, there's an =sumif() function.

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

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