Thanks Luke, it sort of worked! For some reason the formula has made two
rows merge and go grey! any ideas?!

"englishrose4719" wrote:

Can any one tell me how to do the following please? If there is an X in a
cell then take the value from the previous column. ie. if D3 is not null
(has the x in it) then take the cost from C3. Im trying to keep a running
total of expenditure and have all the prices in one column and put an X in
the next column when its been paid for. thanks lots