Results 1 to 4 of 4

Calculating Sums year to date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    469

    Calculating Sums year to date

    hi guys, new to the forum and hoping I can call on your expertise.

    Basically trying to construct a formula which calculates a running YTD (Year to date) value.

    I've attached the file example, layout as follows:
    Column A contains commodities (e.g. coal, wood, rocks)
    Columns B-M contains months Jan - Dec
    Column N contains the YTD value (i.e. if current month = Jun then YTD would = sum of Jan - Jun)

    Im thinking maybe something like a match formula? I've been playing around but just haven't managed to crack it.

    Many thanks
    Neill
    Attached Files Attached Files
    Last edited by NBVC; 10-04-2010 at 08:54 AM. Reason: poor post title

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1