Skipping cells when using SUMPRODUCT function

[Jason]

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

[Bob Phillips]

Jason,

You could use

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

but why not just

=--G2>E2

--
HTH

Bob Phillips

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

"Jason" <Jason@discussions.microsoft.com> wrote in message
news:8BCF4E1C-518C-4358-862E-000F69F53ED8@microsoft.com...
> 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

[Jason]

Bob,

Thanks. Sometimes simple is best.

"Bob Phillips" wrote:

> Jason,
>
> You could use
>
> =SUMPRODUCT(--(MOD(COLUMN(E2:G2),2)=1),--(E2:G2>E2))
>
> but why not just
>
> =--G2>E2
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Jason" <Jason@discussions.microsoft.com> wrote in message
> news:8BCF4E1C-518C-4358-862E-000F69F53ED8@microsoft.com...
> > 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
>
>
>