Cellwise · Understanding your numbers

Multiply and add with SUMPRODUCT

Order values, weighted averages and conditions.

You can total calculated values without a helper column.

This lesson has 4 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.