Excel Frustrations

[Jano]

Putting it bluntly, im pants at Excel. I have a spreadsheet, and I want to add a formula that takes a purchase price and times this by the quantity of items to be ordered for each site. So far I've used the basic =sum(cellX*columnY) Cell X being the purchase price, Column Y being the quantity.

For some annoying reason it works in the first cell, but then tried in the next cell it uses the wrong formula, =sum(CellY*ColumnY)... Why does it do this and how can I stop it?

 

[ed79]

This happens because when you paste the formula in a new place it automatically changes the cell references. You can stop this by putting a $ in front on the letter and or number as required e.g.

change =(a1*b1) to =($a$1*b1)

also you don't need the =sum bit if you're just multplying 2 cells.

http://www.homeandlearn.co.uk/excel2007/excel2007s7p5.html

 

[HEADRAT]

Youtube has some excellent EXCEL "how-to" videos .