IF function

Hi Ross

Thank you for your question.

You need to use SUMIF

It consists of 3 areas.

Range: the area you're using to check the criteria (A1:A21)
Criteria: What you're looking for i.e. 1
Sum range: the area that will be calculated (B1:B21)

I wouldn't recommend using the entire column as this will increase your file size and potentially slow down your sheet

Hope this helps

Kind regards
Wendy Canelas
Microsoft Trainer