Trying to get total mileage for a specific month
Try this:
Total mileage for Jan 2007:
=SUMPRODUCT(TEXT(A19:A64,"YYYYMM"="200701")*G19:G6 4)
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"big_chief_hutch" wrote in message
...
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
|