![]() |
|
#1
|
|||
|
|||
![]()
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) |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
unittwentyfive | Excel | 1 | 10-25-2013 12:56 PM |
![]() |
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |