I have a spreadsheet which shows the date and mileage of business journeys. I
am trying to create a function that will for each month pick out the mileages
for that month and total them up.

Tried the following: =SUMIF(A19:A64,"=01/04/2006",G19:G64) where the A
column is the dates and the G column are the mileages, but I cant seem to set
up an upper limit for the dates. ie Apr journeys only, etc

Help

Big Chief