Hi
=SUMPRODUCT(--ISBLANK(H1:H1000),G1:G1000)

--
Regards
Frank Kabel
Frankfurt, Germany


jim27 wrote:
Hi all

I have two columns of data G and H. I want a formula that will sum
the
numbers column G BUT only those numbers where there is nothing next
to
it in Column H.

Is this possible?

Many thanks.

Jim