Conditional Query

[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

 

[Dave Peterson]

It sounds like =sumif() should work ok for you:

=sumif(o3278,1,n3:n278)

 

[Bill Kuunders]

one way.....

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

Greetings from New Zealand
Bill K

 

[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.