Track input on daily basis

[E. Jones]

Hello all, here is my dilemma:

I have a spreadsheet that lists a number of items that need to be completed by the end of a given week, and the list can range from 100-140 from week to week. I already have working formulas that track the total tasks for the week, how many completed, how many are left to do of each tasks, and the total amount left, the average number needed to complete on a given day to complete the list by the end of the week, and so on.

When a task is completed, I simply put an "X" next to it, and all the calculations are made, including CF that highlight the row as being complete.

What I can't figure out though, is how to track how many tasks I've completed on a given day. For example: I have 100 tasks to do for the week, and on Monday I completed 25 of them, leaving me 75 for the rest of the week. On Tuesday, I completed 10, which now leaves 65 left. What I want is to be able to show a running count for tasks completed on each day, without affecting the tasks that were completed on previous days. Hope that makes sense.

So, Monday would show 25, Tuesday would show 10, and as I complete the tasks on Wednesday, it will sum how many times "X" has been placed in column A on Wednesday only, then the same for Thursday, etc.

I have listed a very abbreviated list below to try to help illustrate what I mean.

As usual, any and all help is much appreciated!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]COMPLETE?[/TD]
[TD="align: center"]TASK[/TD]
[TD="align: center"]DUE BY[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Install new cabinets[/TD]
[TD]Tue[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]X[/TD]
[TD]Paint the walls[/TD]
[TD]Wed[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]Lay the carpet[/TD]
[TD]Wed[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]X[/TD]
[TD]Clean garage[/TD]
[TD]Thu[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]X[/TD]
[TD]Fix plumbing[/TD]
[TD]Fri[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]Paint the walls[/TD]
[TD]Fri[/TD]
[/TR]
</tbody>[/TABLE]

I want to be able to track how many task's I completed on a given day, the actual task completed is unimportant, as the task will appear in column B multiple times.

 

[E. Jones]

I'm interested to hear how the countifs would work, because the best solution for me would in fact be to keep the "X". If I were to do a countifs with the first condition being being an "X", I'm not sure what the second condition would be. How would I know which "X" was done on a particular day?

 

[sheetspread]

Something like:

Excel 2010
	A	B	C	D	E	F	G
1	Complete?	Task	Due By
2		A	1/15/2018
3	X	B	1/16/2018
4		C	1/17/2018
5	X	C	1/18/2018
6	X	A	1/19/2018
7		A	1/19/2018
8
9
10		A	B	C	Total
11	assigned	3	1	2	6
12	completed	1	1	1	3
13	left	2	0	1	3
14
15
16		15-Jan	16-Jan	17-Jan	18-Jan	19-Jan	total
17	assigned for completion by	1	1	1	1	2	6
18	completed	0	1	0	1	1	3
19	left	1	0	1	0	1	3
Sheet21

Cell Formulas
Range	Formula
E11	=SUM(B11:D11)
B11	=COUNTIF($B$2:$B$7,B$10)
B12	=COUNTIFS($A$2:$A$7,"X",$B$2:$B$7,B$10)
B13	=B11-B12
B17	=COUNTIF($C$2:$C$7,B$16)
B18	=COUNTIFS($A$2:$A$7,"X",$C$2:$C$7,B$16)
B19	=B17-B18
G17	=SUM(B17:F17)