View Single Post
  #7   Report Post  
Jason Morin
 
Posts: n/a
Default

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

HTH
Jason
Atlanta, GA

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


.