summing a date range

D

david72

Hi
is their any way if I have a sheet with multiple data and dates, that
the totals can all be summed by date eg

if i have column A with a start date, column b with an end date and
column c with a total in one sheet. can I have another sheet that will
sum the data by date. the end date needs to pickup the previous date
that is listed.

Thanks for your help.
 
P

Paul Lautman

david72 said:
Hi
is their any way if I have a sheet with multiple data and dates, that
the totals can all be summed by date eg

if i have column A with a start date, column b with an end date and
column c with a total in one sheet. can I have another sheet that
will sum the data by date. the end date needs to pickup the previous
date that is listed.

Thanks for your help.
Click to expand...

How's about a pivot table?
 
Top