In my Excel 2007 workbook sheet one keeps track of jobs performed by date, category and a few other data types. The second sheet summarizes the data in a monthly report.
On sheet 1, column A contains the dates, and column E contains the categories.
On sheet 2, cell C2 has the report start date, and cell E2 has the report end date.
In the end I want to count the number of jobs between the start and end dates that match the category "computer".
Thank you in advance for any assistance.
On sheet 1, column A contains the dates, and column E contains the categories.
On sheet 2, cell C2 has the report start date, and cell E2 has the report end date.
In the end I want to count the number of jobs between the start and end dates that match the category "computer".
Thank you in advance for any assistance.
Last edited:
