column sums
 

Hi all

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

Is this possible?

Many thanks.

Ji

--
jim2

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

column sums
 

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