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


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=506190