Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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