Excel whizzes...please help!

LionKing

Hi,

I am trying to put together an Excel spreadsheet but not sure which formula to use.

I would like to achieve the following:

(F2*D2)+(F3*D3)+(F4*D4)+(F5*D5)+(F6*D6)....and so on until (F59*D59)

I would like to display the result in F60.

Is there a quick way of acgieving this as there is a recurring theme or do i have to manually enter above formula.

I did try =SUM((F2:F59)*(D2:D59)) but doesn't work :-(

intel

sum=(d1:d59) but put this formula in d60.

I could be way out as im so rusty.

gustav

K.I.S.S.

i would use another column, say g.
enter =f2*d2 into cell g2
then drag and autofill to g59
hide column g
enter sum(g2:g59) into f60
that should do it

Stompa

I did try =SUM((F2:F59)*(D2:D59)) but doesn't work :-(

=SUMPRODUCT(F2:F59,D2:D59)

might work - except with a colon where the smiley is!

Stompa

mike_paterson

gustav wrote:

K.I.S.S.

i would use another column, say g.
enter =f2*d2 into cell g2
then drag and autofill to g59
hide column g
enter sum(g2:g59) into f60
that should do it

I agree that should work fine !!

robnye

gustav wrote:

K.I.S.S.

i would use another column, say g.
enter =f2*d2 into cell g2
then drag and autofill to g59
hide column g
enter sum(g2:g59) into f60
that should do it

yes that works

SUM((F2:F59)*(D2:D59)) doesnt work,
if you do it as 3 steps then it works but gives a different answer
sumproduct(f2:f59,d2:d59) also works but again gives a strange answer

Chippy_Minton

Quickest way is:

=SUMPRODUCT(F2:F59,D2:D59)

and it gives the correct answer.

tigermatt

When I create Excel spreadsheets, I always use hidden columns and rows instead of typing in long formulas. It makes it easier to manage, quicker to create, and much tidier when a formula is viewed in the formula bar.

e.g. =B23 is much neater than =IF(B2=22," ",VLOOKUP(B2,C2:D6,3))

BLACKHURSTM

Chippy_Minton wrote:

Quickest way is:

=SUMPRODUCT(F2:F59,D2:D59)

and it gives the correct answer.

chippy_Minton has hit the nail on the head.He certainly knows his Excel