summing a date range

[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.

[Paul Lautman]

david72 wrote:
> 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.

How's about a pivot table?