Results 1 to 9 of 9

Adding totals for 2 line with Sumif

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Adding totals for 2 line with Sumif

    Right now I have a column and the formula looks like this.

    =SUMIF('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!E:E)

    It works great and gives me the totals from E:E with the correct corresponding inventory names. How do I get this formula to add some other number from another column. Such as....

    =SUMIF('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!E:E) + ('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!F:F)??

    Essentially I am wanting to add E:E lines and F:F lines together to get one sum with the corresponding inventory ID.
    Last edited by Aussie1; 03-03-2013 at 11:53 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