Results 1 to 10 of 10

Daily data conversion to Monthly totals

Threaded View

  1. 09-09-2013, 11:28 AM #1
    akumagaavese
    akumagaavese is offline
    Registered User
    Join Date
    07-26-2013
    Location
    Norman,USA
    MS-Off Ver
    Excel 2010
    Posts
    45

    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
    Attached Files Attached Files
    Last edited by akumagaavese; 09-09-2013 at 12:21 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. summing daily weekly & monthly totals
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 04:49 PM
  2. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  3. Automatically create monthly totals from daily data
    By mundo in forum Excel General
    Replies: 6
    Last Post: 01-02-2009, 05:33 AM
  4. Find monthly totals from (occasional) daily entries
    By LesserThan in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-06-2008, 12:26 PM
  5. [SOLVED] Collecting weekly and monthly totals from daily data
    By Kasper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2006, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1