I'm trying to multiply and then sum the values in rows 2 and 7 starting with
column J. However, I only want to multiply and sum every other column. My
formula is:

=SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),--(MOD(COLUMN($J7:$BE7),2)=0))

I can't seem to get SUMPRODUCT to work on every other column (starting with
column J).

Any help would be greatly appreciated.

Thanks,
Bob

you are close
try
=SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),$J$2:$BE$2,$J$7:$BE$ 7)
or mod()=1 depending on which columns you want


"Bob" wrote:

I'm trying to multiply and then sum the values in rows 2 and 7 starting with
column J. However, I only want to multiply and sum every other column. My
formula is:

=SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),--(MOD(COLUMN($J7:$BE7),2)=0))

I can't seem to get SUMPRODUCT to work on every other column (starting with
column J).

Any help would be greatly appreciated.

Thanks,
Bob

That did the trick! Thanks a million!

"bj" wrote:

you are close
try
=SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),$J$2:$BE$2,$J$7:$BE$ 7)
or mod()=1 depending on which columns you want


"Bob" wrote:

I'm trying to multiply and then sum the values in rows 2 and 7 starting with
column J. However, I only want to multiply and sum every other column. My
formula is:

=SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),--(MOD(COLUMN($J7:$BE7),2)=0))

I can't seem to get SUMPRODUCT to work on every other column (starting with
column J).

Any help would be greatly appreciated.

Thanks,
Bob