What does it do?
=IF
Allows you to make a logical comparison
Add together a range
=SUM
Multiply
=Count
Count something based on a criteria
=Countif
What does / do
Divide
=SUM
Adds together all selected data
Output a solution if both requirements are met
IF(AND
What does $ do
Ensure cell reference remains absolute
=SUM IF
Adds together a range based on a criteria
Add together a range based on a criteria
A<B mean
A is smaller than B
=Countif
Counts a range based on a criteria
Work out the average based on a criteria
What does ! mean
From a different sheet