summing a date range
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?
|