Geek Answers Handbook

How to calculate the sum of multiplied rows in Excel

Please help me study this sheet:

enter image description here

My current formula is in cell C3. C3=D3*F3+E3*G3+H3*J3+I3*K3I would like to know if there is any better formula because the real sheet has about 30 projects.

Thanks in advance,

+4
source share
3 answers

Assuming your 30 projects go from D3: DS3, try the following formula:

=SUM($D$3:$DS$3*(MOD(COLUMN($D$3:$DS$3),4)=0)*$F$3:$DU$3*(MOD(COLUMN($F$3:$DU$3),4)=2))+
SUM($E$3:$DT$3*(MOD(COLUMN($E$3:$DT$3),4)=1)*$G$3:$DV$3*(MOD(COLUMN($G$3:$DV$3),4)=3))

You need to enter it as an array formula, i.e. instead of clicking Enterat the end, click Ctrl- Shift- Enter!

+3
source

You can use the sumproduct formula to accomplish this task if you are using excel 2007 or higher.

+2
source

,

C3 = PRODUCT(D3:K3)
0

More articles:


All Articles