Results 1 to 2 of 2

Thread: count ifs with date and time | commulative

  1. #1

    Lightbulb count ifs with date and time | commulative



    Register for a FREE account, and/
    or Log in to avoid these ads!

    There is just small help needed in counting function in attached file.
    in attached file If I change due travel day & time both then count status in 2nd Row should show accordingly including Previous travel days also.

    suppose for Example if i need count of 2 day till 20:00 hrs than all count should be included less then 2 including 2 &1 + taking care of time also (means commutative).

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Hi,

    It doesn't work as <=8:00:00 PM is not a condition that excel CountIFs() formula understands. Have a look at the attached file. I have changed the criteria a bit, and also split <=8:00:00 PM into 2 cells.

    CombinedReviewStatusPlanning_SB.xlsx

    Hope this helps
    Cheers
    Sumit Bansal
    Excel MVP (2014-15)
    Founder, Trump Excel

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •