Forum Discussion
Solved
Looking for a formula to help add values of a cell based on what is put in another cell.
Hello! I'm looking for some help figuring out a formula for excel.. I attached an excel file that details the problem. On the 'NDT Hours' sheet, there's an NDT column that contains a drop down list ...
As Detlef_Lewin has already noted, SUMIF will work. It will work most cleanly if you modify your data range to be an official Excel table, as I've done here. You'll be able to add rows and not need to change the formula.
Note: also the formula can then refer to column headings.
=SUMIF(Table2[NDT],Cover!A3,Table2[Hours])
As Detlef_Lewin has already noted, SUMIF will work. It will work most cleanly if you modify your data range to be an official Excel table, as I've done here. You'll be able to add rows and not need to change the formula.
Note: also the formula can then refer to column headings.
=SUMIF(Table2[NDT],Cover!A3,Table2[Hours])
Thank you! I really appreciate it!!