+ Reply to Thread
Results 1 to 6 of 6

to count total open for today

  1. #1
    Forum Contributor
    Join Date
    09-30-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    266

    to count total open for today

    Hi
    I have report with a column B header dates. Column O is status etc open, closed. I need a formula to show with the now function to calculate total opened tickets for the current date.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: to count total open for today

    Try this ...

    =SUMPRODUCT((INT(B2:B1000)=TODAY())*(C2:C1000="open"))

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: to count total open for today

    Try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Forum Contributor
    Join Date
    09-30-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    266

    Re: to count total open for today

    This worked. I have 2 locations to count separately. The sites are in column A. CAn I know how do I integrate this formula to show the totals seperately?
    [=COUNTIFS(B:B,TODAY(),O:O,"open")]

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: to count total open for today

    =COUNTIFS(B:B,TODAY(),O:O,"open",A:A,"Site1")

    where Site1 is site name

  6. #6
    Forum Contributor
    Join Date
    09-30-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    266

    Re: to count total open for today

    It worked perfect. Thanks man.

+ 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. Total number of days from a certain day until today
    By AllisonT in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2014, 04:29 PM
  2. [SOLVED] On file open, automatically scroll to today's date
    By Tony Valko in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-28-2013, 04:13 PM
  3. [SOLVED] When workbook open it show the sheet have today date
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-24-2013, 11:00 AM
  4. Userform: Calender to open with today's date as default
    By Ashali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 07:01 AM
  5. [SOLVED] save currently open file appended with today's date
    By roothog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-05-2011, 10:41 PM
  6. Open file and go directly to TODAY()
    By QueDices in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-04-2010, 05:03 AM
  7. [SOLVED] Open an Excel file with a date as today in a macro
    By Perry in forum Excel General
    Replies: 4
    Last Post: 11-10-2005, 06:00 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