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

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

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

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


.

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" wrote in message
...
=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.


.