+ Reply to Thread
Results 1 to 4 of 4

COUNTA function to count from first cell to date in column header

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    39

    COUNTA function to count from first cell to date in column header

    Hello,
    I have a spreadsheet with the dates of weekdays in row 3 as column headers. I'm looking to use a COUNTA function to count the number of cells with text in a row but to stop counting when it reaches the column with today's date. This to achieve a year to date count of meetings scheduled (Column 'F').

    for example the formula in F18 in row 18 =COUNTA(I18:JH18)

    Instead of the COUNTA function starting at I18 and finishing at JH18, I need it to start at I18 and finish the count at the column that has todays date as a header.

    I've attached an example spread sheet with
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: COUNTA function to count from first cell to date in column header

    Maybe this...

    In G5
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    02-05-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: COUNTA function to count from first cell to date in column header

    That works great mate! Thank you for you help!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: COUNTA function to count from first cell to date in column header

    You're welcome.

+ 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] Count values of column if header name is ...
    By keis386 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2014, 10:52 AM
  2. [SOLVED] Count cell values under column with today's date header
    By jben86 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-23-2013, 03:19 PM
  3. Count Row values based on Column header
    By sramakrishna in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-06-2013, 09:07 AM
  4. Count if values based on column header
    By vijanand1279 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2012, 03:17 PM
  5. [SOLVED] How to CountA for Column Where Header = Something
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-01-2012, 05:48 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