Results 1 to 13 of 13

COUNTIF using current column

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2016
    Location
    ENGLAND
    MS-Off Ver
    365
    Posts
    6

    COUNTIF using current column

    Hi,

    I have the following formula which works fine but i need to do this serveral times with different text

    =COUNTIF($C$3:$C$37,$AN8)

    is it possible to do something like

    =COUNTIF($COLUMN()$3:$COLUMN()$37,$AN8)

    Thanks in advance
    Last edited by Shaun07776; 07-12-2016 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  2. [SOLVED] Modifying current COUNTIF Function
    By zaikun335 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2014, 10:45 PM
  3. [SOLVED] CountIF by Month in current year
    By chatnet26 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-07-2014, 11:58 PM
  4. [SOLVED] Countif or sumproduct for current week
    By acecalder in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 02:40 PM
  5. countif current month excel 2007
    By acecalder in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-06-2013, 03:14 PM
  6. Formula needed for COUNTIF in current month
    By atomickitty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2012, 03:00 PM
  7. COUNTIF and relative offsets from current cells
    By mikejc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2011, 04:08 AM

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