Hello all,
I am trying to create an automated form (field ticket) that collects (Sums) data from a table. Horizontally I have the main criteria, in this case it is a location. Vertically is every date for the rest of year. We invoice every 5 days and have to charge separately by location so on the form I created I put a start date of 10/1/15 and end date of 10/5/15 and then in another cell I list the location (location 1 for this instance) and it sums the volume for that location in that date range...in this case it's 27.
Another example would be:
Start Date: 10/6/15
End Date: 10/10/15
Location 3
Total Volume would equal 40
I was able to get the date ranges correct using SUMIFS and basically saying add anything "on or after Start Date" and "on or before End Date" but could figure out how bring in the Row Data for location. On the form, Would ultimatly like to type in the start and end date, and select what location, and it spits out the totals. This would allow field personnel to only input volumes and not have to do any math for tickets to be signed by customers. Thanks so much for any advice.
I am trying to create an automated form (field ticket) that collects (Sums) data from a table. Horizontally I have the main criteria, in this case it is a location. Vertically is every date for the rest of year. We invoice every 5 days and have to charge separately by location so on the form I created I put a start date of 10/1/15 and end date of 10/5/15 and then in another cell I list the location (location 1 for this instance) and it sums the volume for that location in that date range...in this case it's 27.
Another example would be:
Start Date: 10/6/15
End Date: 10/10/15
Location 3
Total Volume would equal 40
I was able to get the date ranges correct using SUMIFS and basically saying add anything "on or after Start Date" and "on or before End Date" but could figure out how bring in the Row Data for location. On the form, Would ultimatly like to type in the start and end date, and select what location, and it spits out the totals. This would allow field personnel to only input volumes and not have to do any math for tickets to be signed by customers. Thanks so much for any advice.
