Monthly sum

**Syed Haider Ali** · 06-10-2009, 04:08 AM

hi,

I have a two column A and B at Sheet1. Col A is a Date wise column and Col B is of the Values. I need formula for getting sum monthwise in sheet2. i.e the sum of jan, feb, mar etc

Thanks

Syed Haider Ali

**DonkeyOte** · 06-10-2009, 04:18 AM

Two obvious choices:

1 - Use a Pivot Table (grouping Dates by Month (&Year))
2 - Use SUMIF function

In either case - post a sample file if you need more help as it helps us ascertain your desired layout of results.

**dominicb** · 06-10-2009, 04:22 AM

Good morning Syed Haider Ali

Originally Posted by Syed Haider Ali

I have a two column A and B at Sheet1. Col A is a Date wise column and Col B is of the Values. I need formula for getting sum monthwise in sheet2. i.e the sum of jan, feb, mar etc

Use this formula to get one monthly total at a time :
=SUMPRODUCT(--(MONTH(A1:A100)=8),(B1:B100))
This formula will return August's total (ie month 8)

Or you could use a helper column, with a formula like this is column C :
=TEXT(A34,"mmm")
The use Data > Subtotals and subtotal by column C, adding column B

Or you could use a pivot table (Data > Pivot table & pivot chart reports).

HTH

DominicB

**Syed Haider Ali** · 06-10-2009, 07:41 AM

I have attached the sheet, where in sheet "bank_balance" shows a daily markup of the bank, At sheet "Summary" I would like to get automatic sum of markup from sheet "bank_Balance" col H.

Thanks

Syed Haider Ali

**hardeep.kanwar** · 06-10-2009, 08:21 AM

Originally Posted by Syed Haider Ali

I have attached the sheet, where in sheet "bank_balance" shows a daily markup of the bank, At sheet "Summary" I would like to get automatic sum of markup from sheet "bank_Balance" col H.

Thanks

Syed Haider Ali

Try this

and Revert Back for Clarification

**david2005wang** · 06-10-2009, 08:31 AM

Please see the solution, I add one column in the end of sheet2, and if possible, you can set two columns in the end of sheet, one is for month, the other for year.

Hope this can help.

**hardeep.kanwar** · 06-10-2009, 08:36 AM

Originally Posted by hardeep.kanwar

Try this

and Revert Back for Clarification

Sorry May This

**Syed Haider Ali** · 06-10-2009, 09:12 AM

Thanks all of guys

It is solved with your cooperation. But how can it be handle by using sumproduct formula as described by Mr.Dominicb

Syed Haider Ali

**Dahaynes** · 07-10-2009, 12:56 PM

I am looking to do the same thing and the formula works for every month except January. Am I doing something wrong? My formula is:

=SUMPRODUCT(--(MONTH('2009 Tickets'!$B$11:$B$5000)=1),('2009 Tickets'!C$11:C$5000))

**DonkeyOte** · 07-10-2009, 01:00 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.