I will give an example:

G H
1 2
3
3 6



In the above example I want to sum the numbers in G only if there i
nothing next to each figure in H.

So the total for column G would be 3

--
jim2

-----------------------------------------------------------------------
jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=27812