Shortening Formula in Excel 1

[Elvis72]

I am getting the error that the formula is too long, but I'm not a big Excel user.

Here is what I have so far:

=SUM(H8*$F$8/100+H9*$F$9/100+H10*$F$10/100+H11*$F$11/100+H12*$F$12/10
0+H13*$F$13/100+H14*$F$14/100+H15*$F$15/100+H16*$F$16/100+H17*$F$17/10
0+H18*$F$18/100+H19*$F$19/100+H21*$F$21/100+H22*$F$22/100+H23*$F$23/10
0+H24*$F$24/100+H26*$F$26/100+H27*$F$27/100+H28*$F$28/100+H29*$F$29/10
0+H30*$F$30/100+H31*$F$31/100+H32*$F$32/100+H33*$F$33/100+H34*$F$34/10
0+H35*$F$35/100+H36*$F$36/100+H37*$F$37/100+H39*$F$39/100+H40*$F$40/10
0+H41*$F$41/100+H42*$F$42/100+H43*$F$43/100+H44*$F$44/100+H45*$F$45/10
0+H48*$F$48/100+H49*$F$49/100+H50*$F$50/100+H51*$F$51/100+H53*$F$53/10
0+H54*$F$54/100+H55*$F$55/100+H56*$F$56/100+H57*$F$57/100+H58*$F$58/10
0+H59*$F$59/100+H60*$F$60/100+H61*$F$61/100+H63*$F$63/100+H64*$F$64/10
0+H65*$F$65/100+H66*$F$66/100+H67*$F$67/100+H69*$F$69/100+H70*$F$70/10
0+H71*$F$71/100+H73*$F$73/100+H74*$F$74/100+H75*$F$75/100+H77*$F$77/10
0+H78*$F$78/100+H80*$F$80/100+H82*$F$82/100+H83*$F$83/100+H84*$F$84/10
0+H85*$F$85/100+H86*$F$86/100+H87*$F$87/100+H88*$F$88/100+H90*$F$90/10
0+H91*$F$91/100+H93*$F$93/100+H95*$F$95/100+H96*$F$96/100+H97*$F$97/10
0+H98*$F$98/100+H99*$F$99/100+H101*$F$101/100+H103*$F$103/100+H104*$F$
104/100+H105*$F$105/100)

Which works but its too long.

Thanks!~

 

[combo]

Look at SUMPRODUCT function, divide by 100 once.

combo

 

[SkipVought]

Hi,

Make an adjacent column for this calculation. Then just sum the values in this column...
[tt]
=H8*F8/100
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Elvis72]

Skip -

I have columns H through M to do that for....is there a more compact way?

 

[SkipVought]

[tt]
=sumproduct((H8:H105)*($F8:$f105))/100
[/tt]
Just drag across for H:M

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}