Conditional Query

J

jimbob

I have two columns with data, Col N and Col O. If Col O3:O278 has
number =1, I want to take the corresponding value in Col N3:N278 an
sum it with all the other cells in Col N that also have a corrspondin
value=1 in Col O. So, if O3 has a "1", and O4 has a "1", I want to tak
the value for N3 and N4 and sum them
 
B

Bill Kuunders

one way.....

=SUMPRODUCT(--(O3:O278=1),N3:N278)

Greetings from New Zealand
Bill K
 
J

jimbob

Well, I left one little detail out. After I sum the values in N3:N278, I
then need to divide that number by the number of times that a value of
"1" was found in O3:O278. Thanks so much for your help.
 
Top