Using SUMIF with non-blank cells

[Peter Aitken]

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,

 

[Guest]

Hi Peter,

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

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

Regards,
Jon

 

[N Harkawat]

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

 

[Guest]

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

 

[R.VENKATARAMAN]

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

 

[Guest]

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

Lance

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Peter Aitken]

Thanks - Jason your solution is certainly nonintuitive but it works and is
the simplest one.