Hi Doreen

only slightly confused by the sentance
if it's not empty (meaning there's no invoice # there)

this formula will sum column D if there is something in in column E
=SUMIF(E:E,"<"&"",D:D)

this formula will sum column D if there is nothing in column E
=SUMIF(E:E,"",D:D)

(the "" are two double quotes with no space between)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Doreen" wrote in message
...
I have a simple spreadsheet with one column showing amounts owed that I
need
to bill. At the bottom of the column I sum the total amounts. In the
adjacent
column I've started to put the invoice numbers for the ones that have been
billed. I'd like to write a formula that would:
Look at "column e" and
if it's not empty (meaning there's no invoice # there)
add the amount given in "column d"

This way I can subtract that total amount (which has been billed) from the
total amount owed at the bottom...that's where I would like to put the
result
of this formula.

I'm sorry if I'm not explaining this well and I thank everyone for their
help.