chrispy
Board Regular
- Joined
- Apr 26, 2008
- Messages
- 73
I am trying to retrieve information from an existing spread sheet that meets certain criteria.
Column A is a date, Column B is Technicians name, Column C is the sales amount and Column D is number of calls ran that day.
This spreadsheet spans multiple years.
I would like to retrieve the total sales for a particular technician within a specific date range. The beginning date range is in cell AA1, the ending date is in cell AB1, and the technician name is in cell AC1. I would also like to total the number of calls the specified tech ran in the same time period.
Any help on this would be greatly appreciated. Currently I am retrieving the information using filters on the columns but this is cumbersome.
Thanks!
Column A is a date, Column B is Technicians name, Column C is the sales amount and Column D is number of calls ran that day.
This spreadsheet spans multiple years.
I would like to retrieve the total sales for a particular technician within a specific date range. The beginning date range is in cell AA1, the ending date is in cell AB1, and the technician name is in cell AC1. I would also like to total the number of calls the specified tech ran in the same time period.
Any help on this would be greatly appreciated. Currently I am retrieving the information using filters on the columns but this is cumbersome.
Thanks!