Percentage Tally Sum

[excel88]

Hi

I need to be able to add a function so when any date is added to a cell it counts as 1 to eventually work out a percentage.

For example in one spreasheet I know there are 227 tasks to complete, if a date (01.01.24) is entered into a cell, I want to know the percentage complete.
Note the dates will vary prior to completion.

Hope someone has the answer.

 

[Eric W]

Welcome to the MrExcel forum!

Maybe:

Book1
	A	B	C	D
1	Task	Complete Date		Percent complete
2	1			37.5%
3	2	1-Jan
4	3
5	4	3-Jan
6	5
7	6
8	7	2-Jan
9	8
Sheet4

Cell Formulas
Range	Formula
D2	D2	=COUNT(B2:B10)/COUNTA(A2:A10)

 

[felixstraube]

It is not quite clear to me how you want to calculate the percentages is it competed tasks over total number of tasks?
The dates you enter are the completion dates for each task?

 

[excel88]

Apologies I was not very good at explaining this.
I have 227 items each with 13 tasks.
The tasks can be completed on any date and the items do not need to be completed in order.
To enable me to review task progression, I want to see each task status as a percentage:

Ref

Task 1

Task 2

Task 3

Task 4

Task 5

Task 6

Task 7

Task 8

Task 9

Task 10

Task 11

Task 12

Task 13

Totals

1

01.01.24

Task 1

#VALUE!​

2

Task 2

0.00%​

3

Task 3

0.00%​

4

Task 4

0.00%​

5

Task 5

0.00%​

6

Task 6

0.00%​

7

Task 7

0.00%​

8

Task 8

0.00%​

9

Task 9

0.00%​

10

Task 10

0.00%​

11

Task 11

0.00%​

12

Task 12

0.00%​

13

Task 13

0.00%​

 

[excel88]

Welcome to the MrExcel forum!

Maybe:

Book1
	A	B	C	D
1	Task	Complete Date		Percent complete
2	1			37.5%
3	2	1-Jan
4	3
5	4	3-Jan
6	5
7	6
8	7	2-Jan
9	8
Sheet4

Cell Formulas
Range	Formula
D2	D2	=COUNT(B2:B10)/COUNTA(A2:A10)

Hi
This worked thank you.

 

[Eric W]

Sample data can be very helpful in explaining your request. Based on your sample, I'd guess you adapted my formula something like this:

=COUNT(B2:N2)/13

and drag it down. In any case, I'm glad we could help!