+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS without knowing which column

  1. #1
    Registered User
    Join Date
    01-24-2017
    Location
    London
    MS-Off Ver
    2013
    Posts
    5

    COUNTIFS without knowing which column

    I have a dataset containing scores out of five that people have given three products, for a number of different flavours/attributes. I need a count of each score, per product, per attribute. This is easy enough doing each attribute separately, with a simple COUNTIFS: =COUNTIFS($B:$B,J$2,$C:$C,$I3)

    However, to do this I need to know which column the scores are in (in this case, in column C). What I need in this scenario please is a formula that finds the column based on the heading (i.e. 'Sweet' or I2), so to search for the column that has the heading matching I2. Is is some sort of INDEX/,MATCH I need, or an HLOOKUP? Any help much appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: COUNTIFS without knowing which column

    Try

    in J3

    =COUNTIFS(INDEX($C:$G,0,MATCH($I$2,$C$1:$G$1,0)),$I3,$B:$B,J$2)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Countifs - date column by month & second column text value
    By Chelrie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2016, 04:33 PM
  2. [SOLVED] How can I fill a column with dates just knowing beginning and ending month ?
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2015, 03:23 AM
  3. [SOLVED] How to do a Vlookup without knowing the column number
    By funroe in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-09-2013, 06:47 PM
  4. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  5. search a column knowing a cell
    By jimbo_jones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2006, 12:22 PM
  6. [SOLVED] Using Autofill knowing row and column number
    By Fred Smith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2005, 09:06 AM
  7. Replies: 10
    Last Post: 03-20-2005, 02:06 PM

Tags for this Thread

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