In this table, we want to calculate the number of mangoes sold. We are going to click the cell where we want to place the result. Then type in the cell =SUMIF ( We are going to look for the Range. In ...

The SUMIF Function in Excel There are also more complicated functions in Excel that can sum or count values when certain criteria are met.

If you want to count the frequency of a text in Excel, you can use the Countif function. This article explains the step-by-step procedure.