I need help with moving values
I'm fairly new to EXCEL and I could use some help with the following:
if any cell in column "A" has the word "FUEL" then add the value in the cell in column "B" that is to the right of the value in the cell in column "A" to a different cell.
Example: if Cell "A1" says "FUEL" then the value in Cell "B1" is added to cell "D55".
and if Cell "A2" says "FUEL" then the value in Cell "B2" is added to cell "D55"
if Cell "A3" says "REPAIRS" then the value in cell "B3" is not added to cell "D55"
and so for the entire column.
ANY HELP WILL BE GREATLY APPRECIATED.
DAVE WARD
|