Use the COUNT function to count the number of numeric values in a range of cells; for example: C4:C15 contains the quantity of garden tools Mr. McGregor needs to order for his shop. Note that the ...

Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples: =MAX(B4:B13) returns the highest value in the list. =MIN(B4:B13) returns the lowest value ...

the SUMIF function isn't difficult to use, but the easiest way to see it in action is by adding a range of values based on a criterion in that range. For example, suppose you have a spreadsheet ...