| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help calculated total for each month | Excel Worksheet Functions | |||
| Tying names to different values month to month. | Excel Worksheet Functions | |||
| Need look up of month to get total for the month | Excel Programming | |||
| averaging a total out over a month | Excel Discussion (Misc queries) | |||
| 12 month Rolling Total | Excel Worksheet Functions | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
