#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Something along the lines of:
=SUMIF(A1:A20,"FUEL",B1:B20) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 9 | 07-27-2018 02:06 AM |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 6 | 06-09-2018 10:51 PM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Moving cell content without moving borders & shading? | unittwentyfive | Excel | 1 | 10-25-2013 12:56 PM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |