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