Functions

Hello Eason

Thank you for your question and welcome to the forum.

Sumif has three parts: the criteria range, the criteria, and the sum range (if this refers to a different range of cells to the criteria range).

I've attached a spreadsheet with a couple of examples so you can see how the function works.

Kind regards
Amanda