Sum total in S7:S2000 w/ a twist

[James]

Hi,

I need to sum a total in Column S7:S2000 only
if Column Q7:Q2000 is populated(has a number
in it)the sum total will reside in S6,
so it would be something like this:
=Sum(S7:S2000) if Q7:Q2000 is populated,if
any cell in Q7:Q2000 is empty then the cell
in Column S is not added to the total.

Any help on this would be appreciated

Thanks James

 

[dabblerj]

=SUMPRODUCT((D7:D20<>"")*(H7:I20))

This worked for me, thanks for such a quick response. I had been racking my brain for couple of hours, and decided to ask (I never really understood how Product work, still don't but I should probably look it up now).

I've been reading the forums off an on for a few years, but this was my first post!

 

[Aladin Akyurek]

=SUMPRODUCT((D7:D20<>"")*(H7:I20))

This worked for me, thanks for such a quick response. I had been racking my brain for couple of hours, and decided to ask (I never really understood how Product work, still don't but I should probably look it up now).

I've been reading the forums off an on for a few years, but this was my first post!

Also...

=SUM(SUMIF(D7:D20,"<>",H7:H20),SUMIF(D7:D20,"<>",I7:I20))

This allows us to avoid invoking a SumProduct formula with the * syntax.