Results 1 to 8 of 8

Count dates and values in multiple columns

Threaded View

  1. 11-16-2021, 06:46 AM #1
    kris01
    kris01 is offline
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    88

    Count dates and values in multiple columns

    Hi.

    I wish to create a formula (cell H3) that will count the number times (range K1:K9) appears in column D , but only count if there is a date next too it in Column H.

    Not sure if counta or countif works best or its a question of merging the statements together?

    Many Thanks for your help.

    Count.JPG
    Attached Files Attached Files
    Last edited by kris01; 11-16-2021 at 06:54 AM. Reason: Add attachment
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count Multiple Columns by Dates - Line Graph
    By mattycl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2016, 11:44 AM
  2. Pivot Table, Multiple Columns with Text Values, Count is Wrong when adding multiple column
    By jjsharep in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  3. Need to count different values in multiple columns
    By jonez19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2014, 02:47 PM
  4. Count Values between dates and multiple criteria
    By vpapolu24 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2013, 04:48 PM
  5. Count unique values between two dates in two columns
    By hnantz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2012, 05:57 PM
  6. Count unique values in three columns depending on multiple values
    By lainey76 in forum Excel General
    Replies: 16
    Last Post: 01-11-2012, 10:51 AM
  7. Count unique values in one column depending on multiple values in multiple columns
    By redraishes in forum Excel General
    Replies: 5
    Last Post: 04-21-2011, 05:22 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1