+ Reply to Thread
Results 1 to 10 of 10

Count number of activities not started as per plan

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Count number of activities not started as per plan

    I have a sheet in which Column D has Estimated Start date and Column E has Estimated finish date while in Column G it has Actual start date and Column H has Actual End date. Now i want to count number of tasks which were not started as per estimated date.(It should check the estimated start and actual start date, if acual date is greater then estimated it should count those tasks)

    Attached is the sheet for reference, i have inserted expected results as well.

    I am sharing its snapshot as well

    Capture.PNG

    Thank you
    Attached Files Attached Files

  2. #2
    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,193

    Re: Count number of activities not started as per plan

    =SUMPRODUCT(--($G$2:$G$36>$D$2:$D$36))

    It is unnecessary to post a screen shot: a workbook will suffice.
    Last edited by JohnTopley; 04-16-2021 at 04:26 AM.

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Count number of activities not started as per plan

    Thanks and +1 rep. and acknowledged

  4. #4
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Count number of activities not started as per plan

    Sir can we achieve same results with COUNTIF please?

  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,193

    Re: Count number of activities not started as per plan

    Not that I know: what is wrong with SUMPRODUCT?

  6. #6
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Count number of activities not started as per plan

    Actually i want to add another condition. Like it should return results for only those tasks who have "C" in column A

  7. #7
    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,193

    Re: Count number of activities not started as per plan

    .. so why did you not state this originally???

    =SUMPRODUCT(--($G$2:$G$36>$D$2:$D$36)*($A$2:$A$36="C"))

  8. #8
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Count number of activities not started as per plan

    Thank you sir, now its perfect. My Bad, i didn't saw that condition at first.

  9. #9
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Count number of activities not started as per plan

    Quote Originally Posted by Zahid0111 View Post
    Sir can we achieve same results with COUNTIF please?
    For countifs, the helper column is needed.
    I2
    =G2-D2

    then
    =COUNTIFS($I$2:$I$999,">0",$A$2:$A$999,"C")
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Count number of activities not started as per plan

    Oh Great, Thank you. This is also helpful. works great...+1 rep for you as well Sir

+ 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. Count If Between Certain Dates and Activities
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2017, 12:20 AM
  2. Count the total number of plan in a row
    By jamewoong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2015, 11:14 PM
  3. excel, use pivot table to count activities by month and average by activity
    By dreamfalcon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-25-2015, 11:38 AM
  4. [SOLVED] Countif(s): Need to properly count a flight plan
    By 0311 Hesco in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 09-02-2014, 12:17 PM
  5. Replies: 10
    Last Post: 05-11-2012, 02:14 AM
  6. Countif to Count Activities in a time interval on a Specific Date
    By rajxkumar in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-28-2011, 03:55 PM
  7. Pages Count; Plan B
    By Rookie 1st class in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2005, 03:55 PM

Tags for this Thread

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