Excel functions for sales and operations
Sales and operations sheets are mostly orders, regions and statuses. You need to count them, total them and look things up. These functions do that.
Typical jobs
- Total sales by region or product
- Count orders by status
- Find the best week and the quietest one
- Pull a price or customer name from a list using an ID
13 functions to learn
Add up a column or range of numbers
Find the typical value in a set of numbers
Find the highest or lowest value fast
Count rows that meet a condition
Add up only the rows that meet a condition
Count rows that meet several conditions
Add up rows that meet several conditions
Show one result or another based on a test
Choose between three or more outcomes
Combine several tests inside IF
Find a value in a table by its ID
A modern, flexible replacement for VLOOKUP
Look things up in any direction
Other jobs
Unlock every lesson
Every function has a free lesson. Members get all the lessons, fresh exercises every time and the weekly leaderboard. £7 a month or £49 a year, and you can cancel at any time.