Track input on daily basis

E. Jones

Board Regular
Joined
Oct 21, 2012
Messages
59
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!

AB
C​
1COMPLETE?TASKDUE BY
2Install new cabinetsTue
3XPaint the wallsWed
4Lay the carpetWed
5XClean garageThu
6XFix plumbingFri
7Paint the wallsFri

<tbody>
</tbody>

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.
 
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?
 
Upvote 0

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Something like:


Excel 2010
ABCDEFG
1Complete?TaskDue By
2A1/15/2018
3XB1/16/2018
4C1/17/2018
5XC1/18/2018
6XA1/19/2018
7A1/19/2018
8
9
10ABCTotal
11assigned3126
12completed1113
13left2013
14
15
1615-Jan16-Jan17-Jan18-Jan19-Jantotal
17assigned for completion by111126
18completed010113
19left101013
Sheet21
Cell Formulas
RangeFormula
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)
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top