"Eric" wrote:
I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7.
One of these options in G9 should do it:
1. Simplest: =SUM(G3*D3,G5*D5,G7*D7)
2. If intervening cells are blank: =SUMPRODUCT(D3:D7,G3:G7)
3. If intervening cells need to be skipped:
=SUMPRODUCT(--(MOD(ROW(D3:D7),2)=1)*D3:D7*G3:G7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---