• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need an excel formula to sum data basis the month

Hi All,
Please help me in creating an excel formula where i can get the data monthwise. The raw data is mentioned in weeks and i need it monthly. I have uploaded the file for your kind perusal. I have made 2 formulae but its not working.

Ravi Verma


Excel Ninja
Staff member

Firstly, Welcome to the Chandoo.org Forums

Your file isn't attached

To attach a file use the Upload a File button next to Post Reply below

Abhijeet R. Joshi

Active Member
In Cell F3 paste the below formula and drag till F25.
Now, goto cell I3 and paste the below formula there:

Hope this helps...

Sam Mathai Chacko

Active Member
There are many ways to do this. Here's one which doesn't use helper column


and another one that you need to enter as an array formula