Countif on multiple conditions

I'm trying to do a count on multiple conditions . Tried countif and countifs but in vain.

Here's what I'm trying to do. I have three columns "Tasks" , "Baseline" & "Closed" on worksheet 1. In worksheet 2, I have another 3 columns "week ending" , "# of baseline Tasks" and "# of closed tasks" . The last columns must be calculated based on the number of tasks that are ending on that particular week.

Not sure if i managed to explain it clearly. I'm attaching the spreadsheet for reference. Any help is sincerely appreciated.

Perhaps these?

In C4:
=COUNTIFS('Activity Tracker'!J:J,">="&B4-7,'Activity Tracker'!J:J,"<="&B4)

and in D4:

=COUNTIFS('Activity Tracker'!L:L,">="&B4-7,'Activity Tracker'!L:L,"<="&B4)

both copied down.

These count number of date entries that start at weekend date - 7 days to the week ending date...

So are you looking for a cumulative count?

e.g. in C4:

=COUNTIF('Activity Tracker'!J:J,"<="&B4)

in D4

=COUNTIF('Activity Tracker'!L:L,"<="&B4)

It looks like you have cells with dates and times and cells with just dates... they should be consistent and prefer not to have the times.. but you may be able to use formula adjustments as:

=COUNTIF('Activity Tracker'!J:J,"<"&B4+1)

=COUNTIF('Activity Tracker'!L:L,"<"&B4+1)

Select the column(s) and do a CTRL+H. In the Find What field enter a space followed by an asterisk... " *" (without the quotes)

leave the Replace with blank.

Hit Replace All

You are welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save