• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

Excel 2010 Help...

I have a ROW that each clomun is a sum (a function result) of 2 clomuns (from a row under).

i want to know if it's possible to make Excel 2010 do this for me for the next 9 items automatically based on the formula used in first item. (including separated rows and what not)
0
rotem156
Asked:
rotem156
1 Solution
 
barry houdiniCommented:
Try this formula in D2 copied across

=D3*INDEX($B3:$B100,COLUMNS($D3:D3))

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now