+ Reply to Thread
Results 1 to 2 of 2

Counting an INDEX/Match formula answer

Hybrid View

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Lincoln
    MS-Off Ver
    Excel 2003
    Posts
    1

    Counting an INDEX/Match formula answer

    Hi, i am very much stuck with this one and help would be greatly appreciated

    Basically i have a sheet of names with priority on work to do, using index and match i would like to make the cell show me the number of "Low" priority items that a specific person has.

    The names are in Cells E7:E120 and the priority are in cells H7:H120 and have a mix of high, medium and low priority.

    I currently have this code which displays the value "low" in the Cell C3

    =INDEX('Action Steps'!A7:O120,MATCH(B3,'Action Steps'!E7:E120,0), MATCH(C2,'Action Steps'!H7:H120,0))

    This is in sheet 3 and sheet 1 is called Action Steps

    I would like to then count how many "low" priority items say "John Smith" has

    Thank you
    Tom

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Counting an INDEX/Match formula answer

    Maybe (with names in col A and priority in col B):
    =SUMPRODUCT((A2:A100="Name")*(B2:B100="Low"))

+ Reply to Thread

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