Results 1 to 5 of 5

Nested IF statement to recognize root 'codes'

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2009
    Location
    Brisbane
    MS-Off Ver
    Excel 2007
    Posts
    61

    Nested IF statement to recognize root 'codes'

    Yesterday i had an issue recognizing codes which was solved by using the =sumif() function.

    Basically if the code is 110 add together all amounts attached to that code and sum them in a new cell. Perfect.

    Now however there is an added level of complexity and i need to figure out how to nest an IF statement into a =sumif() function so that code amounts are summed into their root code, for example the root code of 110, 120, 130 is 100.

    So basically i want a function that will sum the specific code (110) and then sum together that amount under the root code (100).

    Here is an example.

    The amounts for the lower level codes have been summed but i need the high level codes to be summed together.

    Thank you for your time
    Attached Files Attached Files
    Last edited by Ace of Clubs; 07-06-2009 at 09:37 PM.

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