+ Reply to Thread
Results 1 to 5 of 5

Cell A1 has a date which changes daily i need to capture that into countif equation

  1. #1
    Registered User
    Join Date
    01-25-2017
    Location
    Fiji
    MS-Off Ver
    2013
    Posts
    21

    Post Cell A1 has a date which changes daily i need to capture that into countif equation

    I have created a equation that counts cells in column E containing "Central" if any cell in column B date has the date 23 of jan 2017 and any cell in column F has Telepower.
    the equation works at the moment for a specific date.

    =COUNTIFS(B:B,"1/23/2017",F:F,"Telepower",E:E,"Central")

    What i what to do now is input a date on Cell A1 and what ever date i put on A1 should be used in the equation in place of 1/23/2017

    how can i input this into the equation to pull the date from cell A1

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Cell A1 has a date which changes daily i need to capture that into countif equation

    Hi, welcome to the forum

    Maybe this?
    =COUNTIFS(B:B,$A$1,F:F,"Telepower",E:E,"Central")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-25-2017
    Location
    Fiji
    MS-Off Ver
    2013
    Posts
    21

    Re: Cell A1 has a date which changes daily i need to capture that into countif equation

    Hi thanks i was actually able to solve it. But making it absolute will be more sensible. thanks cheers mate

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Cell A1 has a date which changes daily i need to capture that into countif equation

    Thanks for the feedback

    What did you come up with?

  5. #5
    Registered User
    Join Date
    01-25-2017
    Location
    Fiji
    MS-Off Ver
    2013
    Posts
    21
    Initially before posting i used
    =COUNTIFS(B:B,"A1",F:F,"Telepower",E:E,"Central")
    So i changed it back to the manually inputting the date
    Took me a while to realise da error cell shouldnt be in quotes
    So i just corrected the equation without da quotes
    And after u suggested then made the cell reference absolute

+ 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] create a Dynamic CountIf String for cell equation VBA
    By vpan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2016, 08:49 AM
  2. How can I capture data that is (DAILY) input into another worksheet?
    By Byrd1969 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2016, 01:14 PM
  3. Find Date and Capture Row Number of That Cell
    By ikslohap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2016, 04:27 PM
  4. Capture Daily Excel Sessions for Tracking Changes Made to Cells by Date
    By ChefJon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 07:16 PM
  5. Capture time and activity daily
    By Stormdronk in forum Excel General
    Replies: 0
    Last Post: 08-04-2011, 05:36 AM
  6. How do I capture the Modified date in a cell?
    By rcg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2005, 02:06 PM
  7. Capture cell input date/time
    By Fraggs in forum Excel General
    Replies: 0
    Last Post: 02-03-2005, 12:19 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1