SUM Product formula but with Criteria

[rz6657]

Hi -

I'm currently using the formulas below to sum the positive and negative numbers. Now I have a need it to sum but with a condition that will be in column D, same sheet... Is there a way to modify the formula?

POS
=SUMPRODUCT((SUBTOTAL(2,OFFSET(N$12:N$790,ROW(N$12:N790)-MIN(ROW(N$12:N$790)),,1))*(N$12:N$790>0)*N$12:N$790))

NEG
=SUMPRODUCT((SUBTOTAL(2,OFFSET(N$12:N$790,ROW(N$12:N790)-MIN(ROW(N$12:N$790)),,1))*(N$12:N$790<0)*N$12:N$790))

Thx

Added a sample file---- thx again