+ Reply to Thread
Results 1 to 2 of 2

Countif using VBA from one sheet using date range

  1. 11-21-2020, 11:47 AM #1
    dewdrops
    dewdrops is offline
    Registered User
    Join Date
    10-24-2020
    Location
    Dubai
    MS-Off Ver
    2016
    Posts
    32

    Countif using VBA from one sheet using date range

    Hi...can anyone help with this?

    How to Countif (using VBA) in Sheet 2 Cell H3, for the criteria “Red” in Sheet 1 using a date range in Sheet 1, where the user is required to enter the date from and date to and clicking on a generate button in sheet 2

    Sheet 1
    Col A Col B
    12/03/2020 Red
    12/03/2020 Blue
    14/03/2020 White
    14/03/2020 Red

    Thanks
    Reply With QuoteRegister To Reply
  2. 11-21-2020, 01:39 PM #2
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Countif using VBA from one sheet using date range

    Hi dewdrops,

    With very limited information & no sample file, we have to make some assumptions ... Check attached file 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Countif and date range
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 06:58 AM
  2. COUNTIF used with a DATE range
    By bobbles22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2014, 04:38 AM
  3. COUNTIF over date range
    By alyssa6363 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-24-2013, 12:09 PM
  4. COUNTIF date will expire in a date range
    By neilanderson in forum Excel General
    Replies: 6
    Last Post: 07-31-2012, 02:08 PM
  5. [SOLVED] countif using date range
    By dev111ski in forum Excel General
    Replies: 10
    Last Post: 05-23-2012, 05:44 AM
  6. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  7. [SOLVED] COUNTIF or not to COUNTIF on a range in another sheet
    By Ellie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2005, 05:06 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