Sorry, that doesn't work. Do a sum of the range and then deduct the blanks:

SUM(B:B)-SUMIF(A:A,"",B:B)

Cheers,
Jon

"Springbok" wrote:

Hi Peter,

SUMIF(range,criteria,sum_range). Criteria = "<"""

SUMIF(A:A,"<""",B:B)

Regards,
Jon

"Peter Aitken" wrote:

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.