Skipping cells when using SUMPRODUCT function
 

I am trying to use the following function: SUMPRODUCT(--((E2:G2)E2)) to find
the number of positive changes in this series -- which works well. How would
I do this for JUST E2 and G2 rather than E2, F2, and G2?

Many thanks,

Jason

Skipping cells when using SUMPRODUCT function
 

Jason,

You could use

=SUMPRODUCT(--(MOD(COLUMN(E2:G2),2)=1),--(E2:G2E2))

but why not just

=--G2E2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jason" wrote in message
...
I am trying to use the following function: SUMPRODUCT(--((E2:G2)E2)) to
find
the number of positive changes in this series -- which works well. How
would
I do this for JUST E2 and G2 rather than E2, F2, and G2?

Many thanks,

Jason

Skipping cells when using SUMPRODUCT function
 

Bob,

Thanks. Sometimes simple is best.

"Bob Phillips" wrote:

Jason,

You could use

=SUMPRODUCT(--(MOD(COLUMN(E2:G2),2)=1),--(E2:G2E2))

but why not just

=--G2E2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jason" wrote in message
...
I am trying to use the following function: SUMPRODUCT(--((E2:G2)E2)) to
find
the number of positive changes in this series -- which works well. How
would
I do this for JUST E2 and G2 rather than E2, F2, and G2?

Many thanks,

Jason