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
"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