| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get total mileage for a specific month
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count total month per year | Excel Discussion (Misc queries) | |||
| averaging a total out over a month | Excel Discussion (Misc queries) | |||
| I'm using the mileage log., How do I total all the mileage? | New Users to Excel | |||
| 12 month Rolling Total | Excel Worksheet Functions | |||
| chart: mileage MPG Fuel total paid | Charts and Charting in Excel | |||
Threaded Mode
