In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

You’ll use LAMBDA () functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B, =SUBTRACTL (B3,C3).

2. Track Your Health Excel can help you track calories, exercise and health goals. Once you’ve entered your chosen data, you can manipulate it using formulas and functions.