View Single Post
  #6   Report Post  
LanceB
 
Posts: n/a
Default

=SUMIF(H:H,"<",G:G)

Lance

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