Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by month
I have a file i'm using to calculate invoices and totals, in the summary page i want to create a month by month summary i have read the excel help and i cant find what i need, I am using the DSUM function to calculate a running total which works fine. eg: =DSUM(C$14:G$1015,"Amount",C$1:G$2) but how would i get my sheet to add all the invoices together revcieved in one month if all the dates appear in one column??? and then combine this with my DSUM function to split the incoices into the relevant cost centres??? thanks in advance for any help... this forum has saved me hours of headaches and rage outbursts!! It rules!! -- duncan79 ------------------------------------------------------------------------ duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833 View this thread: http://www.excelforum.com/showthread...hreadid=543243 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
formula: First and last day in month | Excel Worksheet Functions | |||
Referencing data in different worksheet based on month name | Excel Worksheet Functions | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions |