Windows 10: simplify the formula

=C5*D5+C6*D6+C7*D7+C8*D8+C9*D9+C10*D10+C11*D11+C12*D12+C13*D13+C14*D14+C15*D15+C16*D16+C17*D17+C18*D18+C19*D19+C20*D20+C21*D21+C22*D22+C23*D23+C24*D24+C25*D25+C26*D26+C27*D27+C28*D28+C29*D29+C30*D30+C31*D31+C32*D32+C33*D33+C34*D34+C35*D35+C36*D36+C37*D37+C38*D38+C39*D39+C40*D40+C41*D41+C42*D42+C43*D43+C44*D44+C45*D45+C46*D46+C47*D47+C48*D48+C49*D49+C50*D50+C51*D51+C52*D52+C53*D53+C54*D54+C55+D55+C56*D56+C57*D57+C58*D58+C59*D59+C60*D60+C61*D61+C62*D62+C63*D63+C64*D64+C65*D65

:)

 

average formula will not average

I can see three serious problems:

• The "IfError" function suppresses all errors in your formula. You must omit it while debugging the formula.
• You cannot use the "Search" function for a range of cells, only for strings.
• You are posting in the wrong forum (same as you did in January). For a formula as complex as this one you must go to a dedicated Excel forum. Remember to reveal the whole purpose of the formula when reposting instead of just casually throwing in the term
  "Average".
  
  Redirectingmsoffice_excel

 

I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER" IN A SECOND COLUMN.

I SIMPLY WANT TO TRANSFER A FORMULA IN A LIST (COLUMN) TO ANOTHER COLUMN - BUT THE NEW COLUMN - WILL REFLECT THE RESULT OF THE FORMULA. IE
=+DATA!GA TRANSFER TO 132 (OR WHATEVER).

SIMPLY COPYING A LIST OF FORMULAS TO A LIST OF "ANSWERS".

THANK YOU!

 

Vlookup formula not work on window 10 version 1902 & 1903

Hi Ranaraza

There are no reports of those versions of Windows 10 causing problems with Excel formula . . .

Did the formula you are working on previously work or are those new formula?

What version of Excel are you using on your PC?

If that is Office 2016, 2019 or Office 365, and those are previously working formula, please try repairing your Office installation

If those are new formula, please provide the formula that do not work and also the error you are seeing

To repair your Office installation:

Follow these steps to perform a full repair of your Office installation . . .

Open Control Panel - Programs and Features

Click Microsoft Office in the list of installed applications

At the top, click 'Change'

On the resulting dialog, click 'Repair' - choose the Online Repair, it is a comprehensive fix

That should fix any issues with your Office Installation . . .