CHQ auto macro

Need macro to calculate based on date, job name? and total Column A has date Coluimn D has job name (repeated many? times) Column F has total I need: a) a method to calculate by job name the? totals for all? dates b)? a method to calculate by job name the totals for a specific date range that I enter So if I choose (and you need to give me a method to choose/enter the date) a specific date - it will add up all of the totals for each job onthat date only and output one number (all the totals of each job)...in the attached example, the job numbers shown are 420,524 and? 582 - so it must output a total for each. If I choose a date range? (and you need to give me a method to choose/enter the date range) - it will add up all of the totals for each job for that date range and output one number (all the totals of each job)...in the attached example, the job numbers shown are 420,524 and? 582 - so it must output a total for each.