Consider this example

Create this spreadsheet, enter data (including names) and use the correct function to complete the columns F and G.