Need help with SUMPRODUCT
 

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

Need help with SUMPRODUCT
 

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

Need help with SUMPRODUCT
 

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