Results 1 to 8 of 8

Excel 2007 : Sumifs with multipe criteria

Threaded View

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

    Sumifs with multipe criteria

    Hi,

    I want to add up certain number depending on 2 things, 1. by variety (Empire, Cripsin, etc.) and 2. by (FP, MP, Juice). I can get it to add up seperately by "empires" and only by the "FP" but I need to to add up by "empire" AND that are for "FP".

    The formula that I am usings is:

    =SUMIFS(E2:E8000, D2:D8000, "Empire")
    =SUMIFS(E2:E8000, G2:G8000, "FP") I need this formula to add up empire that for for FP.

    Right now the top one is fine for adding certain apple varieties but the bottom formula is all the same for every varieties because I don't know how to specify variety I want for FP.
    Last edited by srgtennis; 02-23-2012 at 02:24 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