Excel

Hello Nora

Thank you for your question and welcome to the forum.

The SUMIF function is used on occasions where you want to create a total, but only for values that match a certain criteria. So add these numbers together for me, but only IF they match a certain criteria.

For example, if you had one column with people's names in it; then the next column contained some numeric value associated with that person (e.g. the amount of a sale they had made; the number of days they had taken off), you could use SUMIF to ask Excel to look at the list of names, use a specific person's name as the criteria to look for, then select the column of values you would like Excel to add from. It is particularly useful if the person's name appears more than once in the list, this way you don't have to manually pick out and add the numbers associated with that person together.

Kind regards
Amanda