+ Reply to Thread
Results 1 to 2 of 2

Formula doesn't work fully - help to fix

  1. #1
    Registered User
    Join Date
    02-18-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    1

    Formula doesn't work fully - help to fix

    Hi,

    The formula I have found for what I want to do is below, but there may be an easier/better one:

    =COUNTIFS(Data!$C:$C,Lists!D1:D2,Data!$F:$F,Lists!$C$1,Data!$G:$G,Lists!A1)

    In column C of the Data tab, this is a drop down list of about five options. I want it to count how many times two of those options appear, if column F matches what is listed in C1 on the Lists tab, and column G matches A1 on the lists tab. The two fields I want it to search for are D1 and D2 on the Lists tab.

    In the above, it will only count D2. I have tred a number of variations but I can't get it to work correctly Any ideas??

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula doesn't work fully - help to fix

    Try it like this...

    =SUMPRODUCT(COUNTIFS(Data!$C:$C,Lists!D1:D2,Data!$F:$F,Lists!$C$1,Data!$G:$G,Lists!A1))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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] Macro doesn't fully work. Need help with rows
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 06:07 PM
  2. Formula Doesn't Work
    By Gene Venzke in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-10-2013, 08:54 PM
  3. formula doesn't work in name
    By foxguy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-29-2011, 10:29 AM
  4. Conditional format in macro, does not fully work
    By SET_student in forum Excel General
    Replies: 4
    Last Post: 02-10-2011, 06:53 AM
  5. Why Doesn't This Formula Work?
    By rockdave35 in forum Excel General
    Replies: 3
    Last Post: 05-18-2009, 04:14 PM
  6. FORMULA DOESN'T WORK
    By Loyd in forum Excel General
    Replies: 4
    Last Post: 03-30-2006, 01:20 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