Step-by-Step 1 – Using the SUMIF Function

, which means that VLOOKUP can check for the nearest value that does not go over the number in the first column; the same bonus is paid for a range of years, so you enter True in the Range_lookup box so that a value will be returned for all agents. ................
................