How to use the Countifs function to count multiple items based on a date range in Microsoft Excel. This is a Microsoft Excel tutorial covering, Countifs, named ranges and the Today() function. The tutor starts off by explaining how the Countifs function works and demonstrates it on an example. The tutor then recreates the example, naming both columns and setting a small criteria table up. Once the table is set the tutor uses the countifs function to count all completes within the last ten days and all the overdue within the last ten days.