Results 1 to 4 of 4

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

Threaded View

  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

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