+ Reply to Thread
Results 1 to 3 of 3

Sum of numbers but dependant upon another columns entry

  1. #1
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Smile Sum of numbers but dependant upon another columns entry

    Hi Folks,

    Is it possible to achieve the following?

    I want to show the number of weeks remaining from the sum of a column BUT I want it to distinguish between the entry in another column.

    See below.

    Columns B to L represent a number of weeks

    EG1
    Column C: Year 1 has a set amount of 47 and C156 displays this.
    C157 should display the amount of weeks in Column C but only when a number "1" appears in Column "Y"
    C158 displays the total amount remaining

    EG2
    Column H: Year 2 has a set amount of 38 and H160 displays this.
    H161 should display the amount of weeks in Column C but only when a number "2" appears in Column "Y"
    C162 displays the total amount remaining

    Is this possible?

    Thanks
    Attached Files Attached Files
    Last edited by Sgt.Trojan; 04-06-2009 at 05:58 AM. Reason: Solved

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Sum of numbers but dependant upon another columns entry

    check out SUMIF function in XL Help, eg:

    C157: =SUMIF($Y$3:$Y$154,1,C$3:C$154)
    can be applied to all cells in range B157:L157

    I think you should be able to work out Year 2...

  3. #3
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Sum of numbers but dependant upon another columns entry

    C161: =SUMIF($Y$3:$Y$154,2,C$3:C$154)

    I thank you

+ Reply to Thread

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