Results 1 to 7 of 7

Sum in accordance to another cell

Threaded View

  1. #1
    Forum Contributor gilbert's Avatar
    Join Date
    01-08-2004
    Location
    Asia
    MS-Off Ver
    2007
    Posts
    117

    Sum in accordance to another cell

    \1

    From the above diagram, can anyone help me with a formula for Accumulated cell in Last Year? Basically, this auto sum has to correspondence with the figures entered into This Year cells (ie. if 2 cells have figures, the Accumulated cells in Last Year will sum up 2 cells only and so forth)

    Please help.

    P/S : If you difficulties in viewing the above picture... here is a text format

    Jan Feb Mac Apr May Jun Accumulated Total
    Last yr 100 130 150 250 500 120 380 1250
    This yr 200 150 300 650 650
    Last edited by gilbert; 07-06-2010 at 05:49 AM. Reason: Problem Solved! Thanks to forum contributors
    Thank you in advance,
    Gilbert

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