Tomatoes originated from the Andes, in what is now called Peru, Bolivia, Chile and Ecuador - where they grew wild. They were first cultivated by the Aztecs and Incas as early as 700 AD.
1. Click any single cell inside a data set. 2. On the Data tab, click Filter. Arrows in the column headers appear. 3. Click the arrow next to Date. 4. Click on Select All to clear all the check boxes, click the + sign next to 2012, and click the check box next to January. 5. Click OK. Result.
Verify the Total. In this example, the result for the selected date range is a total of 494 units sold. To verify, you can select cells B3:B6, and look at the total shown in Excel's Status Bar. To get the total units for a different date range, change the Start date in cell D2, and/or the End date in cell E2. If youâre using Excel 2003, the SUMIFS function isnât available, but you can calculate the total for a date range with the SUMIF function.