sumproduct

[jack]

I have two non adjacent columns and also non adjacent rows
that I like to use with a SUMPRODUCT formula.

How do you do that?

Say I have cells:
A1 C1
A3 C3
A5 C5

Etc?

Thanks group.

Jack.

 

[Frank Kabel]

Hi
and what do you want to calculate? do you mean
=SUMPRODUCT(A1:A5,C1:C5,--(MOD(ROW(A1:A5),2)=1)))

 

[jack]

sorry,
Yes, I want to calculate sumproduct of a1*c1 +a3*c3 etc.
What is the Mod function you're suggesting? should I
include that?

Jack

 

[Frank Kabel]

Hi
yes include this. This function returns 1 for rows 1,3,5,... and 0 for
rows 2,4,6,..
You can shorten the formula to:
=SUMPRODUCT(A1:A5,C1:C5,MOD(ROW(A1:A5),2))

 

[jack]

thank you

-----Original Message-----
Hi
yes include this. This function returns 1 for rows 1,3,5,... and 0 for
rows 2,4,6,..
You can shorten the formula to:
=SUMPRODUCT(A1:A5,C1:C5,MOD(ROW(A1:A5),2))

--
Regards
Frank Kabel
Frankfurt, Germany



.