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
SUMBeginner
Add up a column or range of numbers
6 lessons · 1 freeLearn it
AVERAGEBeginner
Find the typical value in a set of numbers
6 lessons · 1 freeLearn it
MAX / MINBeginner
Find the highest or lowest value fast
5 lessons · 1 freeLearn it
COUNTIFIntermediate
Count rows that meet a condition
6 lessons · 1 freeLearn it
SUMIFIntermediate
Add up only the rows that meet a condition
5 lessons · 1 freeLearn it
COUNTIFSIntermediate
Count rows that meet several conditions
5 lessons · 1 freeLearn it
SUMIFSIntermediate
Add up rows that meet several conditions
6 lessons · 1 freeLearn it
IFIntermediate
Show one result or another based on a test
6 lessons · 1 freeLearn it
Nested IFIntermediate
Choose between three or more outcomes
5 lessons · 1 freeLearn it
AND / ORIntermediate
Combine several tests inside IF
5 lessons · 1 freeLearn it
VLOOKUPIntermediate
Find a value in a table by its ID
6 lessons · 1 freeLearn it
XLOOKUPIntermediate
A modern, flexible replacement for VLOOKUP
6 lessons · 1 freeLearn it
INDEX / MATCHAdvanced
Look things up in any direction
5 lessons · 1 freeLearn it