I just Had that issue solved!
You can use something like this, just adjust your ranges!

=SUMIF($B$2:$B$12,"",$A$2:$A$12)

In this case, everything in the range B2:B12 that has an empty space
will add the values in their respective A column.
Just beware that instead of NOTHING you don't have a BLANK SPACE, or it
will fail.
If you want to check for BLANK SPACES just change it to

=SUMIF($B$2:$B$12," ",$A$2:$A$12)


--
Hanzo
------------------------------------------------------------------------
Hanzo's Profile: http://www.excelforum.com/member.php...o&userid=29955
View this thread: http://www.excelforum.com/showthread...hreadid=496536