Results 1 to 2 of 2

Array formula to count based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    77

    Array formula to count based on multiple conditions

    Hi All

    I am struggling to know how to get an array formula working. Any help would be massively appreciated.

    I need to count the number of times that the value of cell B39 shows in range A3:A33 and also the number of times that a non zero quantity is present in range E3:E33. Both criteria must be met before cell is counted.

    The formula i have at present is:


    {=SUM((A3:A33=B39)*(E3:E33>0))}
    This returns a value of 6, as there is 6 cells in A3:A33 with the value of B39. However there is no corresponding cells in range E3;E33 with a positive value - so result should be zero.

    Hope this makes sense

    Thanks
    Mark
    Last edited by markrennolds; 11-09-2010 at 06:57 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