SUMIF and SUMIFS function is used to add data or seperate data in a table or column. We dicuss the difference and how to use them.

Robynne Sisco, CFO, Workday “SUMIF is my favorite spreadsheet function. I find the ability to sum only certain numbers in a column if they meet certain criteria fascinating.

The SUMIF function provides a quick and simple way to create a sum based on a specific criterion, such as the type of audit.

VIDEO: These functions in Excel let you summarize data based on different characteristics.