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():
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
Then you can copy down.