column sums
 

Comes up with zero as the sum. I think this is because there is
formula in all the cells in H. How can I get around this so it jus
picks up the numbers?

Thank

--
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
then try:
=SUMPRODUCT(--(H1:H1000=""),G1:G1000)

--
Regards
Frank Kabel
Frankfurt, Germany


jim27 wrote:
Comes up with zero as the sum. I think this is because there is a
formula in all the cells in H. How can I get around this so it just
picks up the numbers?

Thanks