I have a table that looks like this:
In cell F2 I would like to have the sum of all values in column B where the value in the cell next to it (C column) is equal to "Niels".
How could I do this? (I'm a beginner with Excel)
I have a table that looks like this:
In cell F2 I would like to have the sum of all values in column B where the value in the cell next to it (C column) is equal to "Niels".
How could I do this? (I'm a beginner with Excel)
You can do this with SUMIF():
=SUMIF(C:C,"Niels",B:B)
You can also use the data in E directly in the formula so you do not need to retype the formula for each, in E2 put just Niels
=SUMIF(C:C,E2,B:B)
Then you can copy down.