+ Reply to Thread
Results 1 to 30 of 30

Need formula to count table range depending on conditions in selected table columns

Hybrid View

  1. 05-26-2022, 03:16 AM #1
    ardross
    ardross is offline
    Registered User
    Join Date
    03-01-2022
    Location
    Eire
    MS-Off Ver
    O365 Beta
    Posts
    89

    Re: Need formula to count table range depending on conditions in selected table columns

    Can you add some expected results to your sample file? I do not follow the explanation...
    Reply With QuoteRegister To Reply
  2. 05-26-2022, 03:27 AM #2
    jj2105
    jj2105 is offline
    Registered User
    Join Date
    05-25-2022
    Location
    adelaide
    MS-Off Ver
    2016
    Posts
    34

    Re: Need formula to count table range depending on conditions in selected table columns

    Quote Originally Posted by ardross View Post
    Can you add some expected results to your sample file? I do not follow the explanation...
    Done,

    So I'm looking for Number of Hits (i changed the heading)= 16 (in Aggressive), Number Of misses etc, hopefully that makes sense
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a pivot table to display all the columns from the original table for the selected ro
    By Vaderalan in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-28-2020, 10:30 AM
  2. populate table with data depending on item selected in drop down list
    By AbertBean in forum Excel General
    Replies: 16
    Last Post: 01-25-2018, 12:18 PM
  3. Populate a table depending on dropdown data selected
    By ftrindade in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2017, 07:08 AM
  4. [SOLVED] table(A) as an array using all rows but only selected columns to compare with table(B)
    By se3unlock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2015, 10:15 AM
  5. How to find results from a table given the conditions selected in sepparate cells.
    By dvillagol in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2014, 09:07 PM
  6. Trying to add additional data into a specific row of a table depending on row selected VBA
    By Carling73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2013, 08:40 PM
  7. How to count frequency of items in the table (given 2 columns in a table)
    By xianwinwin in forum Excel General
    Replies: 5
    Last Post: 06-22-2010, 03:17 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1