Microsoft Excel 2000.
I have three columns as below:
Date Time Litres
I want to be able to sum the litres between a specified date and time range. (This range will be determined by the contents of four more cells containing Start Date, Start Time, End Date and End Time - these cells can have the values changed by the user in order to re-calculate the litres).
How can this be done - am I missing something really simple?
I have three columns as below:
Date Time Litres
I want to be able to sum the litres between a specified date and time range. (This range will be determined by the contents of four more cells containing Start Date, Start Time, End Date and End Time - these cells can have the values changed by the user in order to re-calculate the litres).
How can this be done - am I missing something really simple?