Using SUMIF with non-blank cells

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.

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

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

"Peter Aitken" <paitken@CRAPnc.rr.com> wrote in message
news:%23Y%23jeQ3DFHA.3728@TK2MSFTNGP14.phx.gbl...
>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.
>

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

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




Peter Aitken <paitken@CRAPnc.rr.com> wrote in message
news:#Y#jeQ3DFHA.3728@TK2MSFTNGP14.phx.gbl...
> 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.
>
>

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

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

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

--
Peter Aitken

Remove the crap from my email address before using.

"Jason Morin" <jasonjmorin@OPPOSITEOFCOLDmail.com> wrote in message
news:0d8501c50f77$9a907350$a401280a@phx.gbl...
> =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.
>>
>>
>>.
>>