thanks Luke, it sort of worked! For some reason the formula has merged two
rows and gone grey! any ideas? ER

"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