Need help with SUMPRODUCT

[Bob]

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

 

[bj]

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]

That did the trick! Thanks a million!

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