How to use the COUNTIF function to count values in Excel
In this example, we will be using the COUNTIF function to count specific values in a worksheet. We will be using a price list and will try to determine how many products in the price list cost more than $500. The COUNTIF function will count the number of cells in a range that meet this [...]
How to use the SUMIF function within a formula in Excel
In this example, all the sales of different restaurant branch regions have to be summed up. You can use the SUMIF function to add all cells in a range, specified by a given criteria.
Here is the syntax for the function: SUMIF(range, criteria, sum_range)
Range: A range of cells to be evaluated.
Criteria: The criteria that specifies which [...]
