Can combine the IF functionality with a number of functions, such as SUMIF and COUNTIF
=SUMIF(Range,Criteria,Range to SUM)
This function will only sum the values in a range that meet the criteria you have specified
=COUNTIF(Range,Criteria)
This function will only count the values in a range that meet the criteria you have specified
Once we get used to the basics, the IF function can be combined with a number of them
We’ll use SUMIF as an example.
This will only SUM the values in the range, IF the criteria we specify have been met.
We’ll use an example to demonstrate
SUMIF, need to restock is Yes
Here we want to find out the total to restock.
We only want to SUM then Yes’ in the “Need to Restock” column
Our Range, is the “Need to Restock” column
The criteria is that it needs to be “Yes”
The Range to sum, is the “Amount to restock column”