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
|