column sums

[jim27]

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

 

[Ken Wright]

Then I'm assuming you have formulas in H that return "" for a certain condition,
so

=SUMPRODUCT((H1:H1000="")*(G1:G1000))

or maybe

=SUMPRODUCT((H1:H1000=0)*(G1:G1000))

unless 0 is a viable number in H that may appear and you wouldn't want counted.