Daily data conversion to Monthly totals

Sorry guys. I uploaded a wrong file.

Hey Guys. I have a daily rainfall data and I want to convert it to monthly totals. I tried the pivotal table but the arrangement of the data seemed to be confussing(i.e the year, month and day are in different columns). Please see the attached data and help me out. Thanks

Perhaps this will help you out. The daily data is grouped on Year and Month.

Put this formula in C3:

Formula:

Please Login or Register  to view this content.

and copy down.

Then put this formula in K6:

Formula:

Please Login or Register  to view this content.

and copy that across and down your table.

Hope this helps.

Pete

Are you seeking for Formula based approach or Pivot Table base..

unsure which one you wanted so i did both so you can see what they look like

ohh..thats where it went.....

the basics of pivot table
Highlight all our data so B1:F14174
on your ribbon bar
select "insert" and then click "Pivot table"

this you pop up a menu to create the pivot table, click ok
on a new sheet will be pivot table field list
its a simple click and drag process
put station and Year in row label
put month in column label
and then put rain into values box

sounds like a handful but really it isnt
if you got lost anywhere along that
http://fiveminutelessons.com/learn-m...ot-table-excel
this may help you understand the basics of pivot table

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.