Results 1 to 11 of 11

Excel 2007 : I need to add 2 different items names up into this one box useing sumifs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    255

    I need to add 2 different items names up into this one box useing sumifs

    Here is my formula, it works great but it only add up "Mixed Juice" when I enter that in. I would like it to add up these other apples when I put in goldens and gala, and etc. It is for inventory and so right now this cell adds up only mixed juice in room 5 that is Juice, so I need it to add up mixed juice and goldens that are in room 5 and juice into one number.

    =SUMIFS('Data Sheet'!F3:F8007, 'Data Sheet'!E3:E8007, "Mixed Juice", 'Data Sheet'!H3:H8007, "Juice", 'Data Sheet'!I3:I8007, "5")-'Data Sheet'!T61-SUMIFS('Data Sheet'!N3:N8007, 'Data Sheet'!L3:L8007, "Mixed Juice", 'Data Sheet'!Q3:Q8007, "5")+SUMIFS('Data Sheet'!M3:M8007, 'Data Sheet'!L3:L8007, "Mixed Juice", 'Data Sheet'!Q3:Q8007, "5")

    I tried this but it didn't work (just added goldens to it):

    =SUMIFS('Data Sheet'!F3:F8007, 'Data Sheet'!E3:E8007, "Mixed Juice", 'Data Sheet'!E3:E8007, "Goldens", 'Data Sheet'!H3:H8007, "Juice", 'Data Sheet'!I3:I8007, "5")-'Data Sheet'!T61-SUMIFS('Data Sheet'!N3:N8007, 'Data Sheet'!L3:L8007, "Mixed Juice", 'Data Sheet'!Q3:Q8007, "5")+SUMIFS('Data Sheet'!M3:M8007, 'Data Sheet'!L3:L8007, "Mixed Juice", 'Data Sheet'!Q3:Q8007, "5")

    Please help thanks.
    Last edited by srgtennis; 03-01-2012 at 01:35 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