+ Reply to Thread
Results 1 to 6 of 6

Count specific wording in column heading

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Count specific wording in column heading

    Hello All

    Please see attached.

    I need a formula in column AD that will do the following.

    - Look in columns AT, BH, BM, BO, and return ONLY the total count of cells that are blank, read "0", or "Assigned".

    Let me know if you need further clarification
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Re: Count specific wording in column heading

    I hope that I have given a decent explanation of my issue. I apologize if I have titled a thread in a manner that is difficult to comprehend. At the end of the day, I believe I need some sort of count if help.

  3. #3
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Re: Count specific wording in column heading

    Please help

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,312

    Re: Count specific wording in column heading

    Maybe something like this: =SUM(COUNTIF(A1:A5,{"Assigned",0,""}))

    Adjust it for your range
    HTH
    Regards, Jeff

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Count specific wording in column heading

    This is my interpretation of what I think you are asking:
    Enter this in AD5 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

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

    Re: Count specific wording in column heading

    Here's another one...

    =SUM(COUNTIF(INDIRECT({"AT5","BH5","BM5","BO5"}),{"";0;"Assigned"}))
    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. Count number of cell with specific wording
    By Tttbone in forum Excel General
    Replies: 1
    Last Post: 10-27-2014, 04:37 PM
  2. [SOLVED] Only count data from column with a particular heading
    By codyryan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-18-2014, 07:09 PM
  3. [SOLVED] VBA Count Records Which Match Column Heading
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-20-2014, 05:24 AM
  4. Macro to delete column if it contains specific wording
    By swoods118 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2013, 01:16 PM
  5. [SOLVED] Copy and Paste a specific Column to a Column that's heading matches a particular cell
    By Rexmond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 12:29 AM
  6. Count if column heading is
    By nd2828 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2012, 03:08 PM
  7. Replies: 1
    Last Post: 04-03-2012, 05:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1