Probably simple, but I cannot figure it out.
I need to sum Column I (each row in I is the sum of G & H) only if rows in
columns G & H have a value.
HELP please.

Try this:

=SUMPRODUCT(--(G1:G100<""),--(H1:H100<""),(I1:I100))

HTH,
Elkar


"monkey1964" wrote:

Probably simple, but I cannot figure it out.
I need to sum Column I (each row in I is the sum of G & H) only if rows in
columns G & H have a value.
HELP please.

Thank you. I believe I need it differently now though.
I need it to sum up column J only if BOTH G & H cells have a value. I tried
using the formula you gave me for it, but it only gave me a 0. Your formula
did work for summing up I. Column J is a formula for Cost Difference between
Columns F & I.


"Elkar" wrote:

Try this:

=SUMPRODUCT(--(G1:G100<""),--(H1:H100<""),(I1:I100))

HTH,
Elkar


"monkey1964" wrote:

Probably simple, but I cannot figure it out.
I need to sum Column I (each row in I is the sum of G & H) only if rows in
columns G & H have a value.
HELP please.

This should work:

=SUMPRODUCT(--(G1:G100<""),--(H1:H100<""),(J1:J100))

We just changed the (I1:I100) part to (J1:J100) since you want to maintain
the same conditions, but just sum a different column.

HTH,
Elkar


"monkey1964" wrote:

Thank you. I believe I need it differently now though.
I need it to sum up column J only if BOTH G & H cells have a value. I tried
using the formula you gave me for it, but it only gave me a 0. Your formula
did work for summing up I. Column J is a formula for Cost Difference between
Columns F & I.


"Elkar" wrote:

Try this:

=SUMPRODUCT(--(G1:G100<""),--(H1:H100<""),(I1:I100))

HTH,
Elkar


"monkey1964" wrote:

Probably simple, but I cannot figure it out.
I need to sum Column I (each row in I is the sum of G & H) only if rows in
columns G & H have a value.
HELP please.

monkey1964 wrote:
I need to sum Column I (each row in I is the sum of G & H) only
if rows in columns G & H have a value.

If you truly mean if there is a value in __both__ G and H:

=sumproduct((G1:G10<"")*(H1:H10<"")*I1:I10)

Thank so much! That one did the trick!


" wrote:

monkey1964 wrote:
I need to sum Column I (each row in I is the sum of G & H) only
if rows in columns G & H have a value.

If you truly mean if there is a value in __both__ G and H:

=sumproduct((G1:G10<"")*(H1:H10<"")*I1:I10)