Hello!
I am creating a date table to count certain events which have occured over 24 hours ago.
Thanks to help in this forum, i am using the following formula for this:
=COUNTIF(A2:A100,"<="&H1-1)
The events are in column A and todays date is in cell H1.
I need to add another column to this table which shows whether the event is Complete or Incomplete. These will be in I2:I100 in the same table
I need to add the total of events that happened yesterday which are still incomplete.
How do i do this?
Thank you in advance!!!!
Bookmarks