Sums by month/quarter

squacky · Apr 30th, 2002, 08:40 AM

I have a running list of transactions on a single sheet with columns: B:DATE, C:DEPARTMENT, D:VALUE.

I need to total these by MONTH and QUARTER for all transactions and by individual department.

I could use some help with the following formulas:

Monthly Total = SUM(of all transaction from that month)

Department Monthly Total = SUM(all transactions by that department from that month).

I need to do both of these by the quarter as well. Any suggestions would be appreciated =)

Mark W. · Apr 30th, 2002, 08:47 AM

Have you considered using PivotTables?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 08:40 AM	#1
squacky New Member Join Date: Apr 2002 Posts: 1	I have a running list of transactions on a single sheet with columns: B:DATE, C:DEPARTMENT, D:VALUE. I need to total these by MONTH and QUARTER for all transactions and by individual department. I could use some help with the following formulas: Monthly Total = SUM(of all transaction from that month) Department Monthly Total = SUM(all transactions by that department from that month). I need to do both of these by the quarter as well. Any suggestions would be appreciated =)

Apr 30th, 2002, 08:47 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Have you considered using PivotTables?