The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples.
This guide to the SUMIF Excel function will show you how to use it, step-by-step. As a financial analyst, SUMIF is a frequently used function. Suppose we are given a table listing the consignments of vegetables from different suppliers.
The SUMIF function of Microsoft Excel sums the values in a range of cells if certain criteria is met. This tutorial teaches the SUMIF function and provides 10 unique examples. For multiple criteria, use the SUMIFS function. This tutorial contains links to products some readers may find helpful.