column sums
 

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

column sums
 

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"jim27" wrote in message
...

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 is
nothing next to each figure in H.

So the total for column G would be 3.


--
jim27


------------------------------------------------------------------------
jim27's Profile:
http://www.excelforum.com/member.php...o&userid=15379
View this thread: http://www.excelforum.com/showthread...hreadid=278120



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004