Today you will

• use IF to give each row a clear status
• use SUMIF and COUNTIF to add up or count only the rows you want
• add one labelled formula to your own project workbook

IF tests one condition. It gives one answer if the condition is true and a different answer if it is false.

SUMIF adds up numbers only in the rows that match a rule, such as Online sales.

COUNTIF counts how many rows match a rule, such as how many items are on target.

Example

{{code:=IF(C2>=50,"On target","Below target")}} shows On target when a tote bag sells 50 or more.

Later you can also try nested IF, IFS and AVERAGEIF.

You will build Aoife's tote-bag sheet with your teacher. Aoife sells tote bags at a local market and online. Follow the steps in the box below. The steps marked Stretch are extra, so only do them if you have time.

Type this into your new sheet:

When you finish, Online revenue should show {{code:1670}} and Items on target should show {{code:3}}.

Common snags

• The formula shows as text. Make sure the cell starts with {{code:=}} and has no space before it.
• You see {{code:#NAME?}} The function name is spelled wrong, so type it again carefully.
• SUMIF or COUNTIF shows 0. Check that the word in quotes matches the sheet exactly, with no extra spaces.