=sumproduct(--isblank(h1:h1000),(g1:g1000))
adjust the range accordingly

"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.