try this

=SUMPRODUCT(--(G1:G7),--(H1:H7<0))

the signs are two minus signs

my data is G1 to G7 change it to suit your purposes




Peter Aitken wrote in message
...
I want to use SUMIF to sum the numbers in column G only if the adjacent
cell
in column H is not empty. I cannot figure out the criterion to use.

Thanks,

--
Peter Aitken

Remove the crap from my email address before using.