View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Stout[_2_] Les Stout[_2_] is offline
external usenet poster
 
Posts: 396
Default Total up values for one month

Hello all, i need help desperatly with the following. I have a spread
sheet with values as below in columns A to F and need to total the
values in "F" based on the date in colummn "E". Total for May is 176 and
for April is 99...
I hope that i have explained myself ok, i need to do this with code as
the spread sheet is very long and i have to do from Jan to July...


VPRD 101 8600389020 1 05/05/07 1
VPRD 101 8600388404 1 04/05/07 52
VPRD 101 8600383052 1 04/05/07 4
VPRD 101 8600381932 1 03/05/07 70
VPRD 101 8600378549 1 03/05/07 5
VPRD 101 8600377924 1 02/05/07 44
VPRD 101 8600373000 1 27/04/07 3
VPRD 101 8600372099 1 26/04/07 53
VPRD 101 8600366108 1 26/04/07 4
VPRD 101 8600365754 1 25/04/07 36
VPRD 101 8600360596 1 25/04/07 3

Thank you in advance for any help


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***