+ Reply to Thread
Results 1 to 2 of 2

A formula needed that will sum below if critieria in 2 collumns fulfilled by row....

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    nyc
    MS-Off Ver
    2010
    Posts
    1

    A formula needed that will sum below if critieria in 2 collumns fulfilled by row....

    I would like help with a formula that will sum all in collumn B, if there is a quantity greater than $1500 in collumn C and also a quantity greater than $1500 in collumn B.
    If a door does not have quantities in both collumns B and C individually greater than $1500, then I do not want it to be in the grand total (like for like) below.

    a b c
    Door # ty ly
    3118 $65,735 $59,759
    3122 $0 $0
    3124 $62,215 $56,559
    3126 $0 $45,060
    3127 $65,857 $59,870
    3132 $88,626

    like for like $193,807 $176,188

    Any good ideas out there?

    Tiffanie

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,697

    Re: A formula needed that will sum below if critieria in 2 collumns fulfilled by row....

    Try using SUMIFS

    =SUMIFS(B:B,B:B,">1500",C:C,">1500")
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to fill a cell with formula if condition fulfilled
    By ruliansyah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2013, 05:29 AM
  2. How to Find When Shortge qty is Getting Fulfilled?
    By Rajeshkumar R in forum Excel General
    Replies: 7
    Last Post: 03-22-2012, 04:44 AM
  3. Importing worksheets if certain condition is fulfilled
    By missf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2011, 07:59 AM
  4. Replies: 3
    Last Post: 12-01-2009, 05:16 AM
  5. Choosing a formula to used based on a codition fulfilled
    By The Big Dog in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 12:05 PM

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