Counts with multiple criteria

There are times when you will need to summarize data based on multiple criteria. You can use the AVERAGEIFS(), COUNTIFS(), and SUMIFS() functions to specify multiple criteria. Recall that these functions take pairs of ranges and criteria to include only the cells that meet the specified conditions.

Now you'll tally the number of crimes that occur after 8:00 in the evening. A couple of reminders:

• Remember that the time data are stored in 24-hour format.
• You can specify comparison arguments by including the operator in the criterion (e.g., "<900").