count value with two references

[Daniel Valle]

Hi, can anybody help me with this

I need to find the count value with two references to get the count progress %

In Col A I have a formula with Weeknum, that comes from a date, indicate that was counted

In Col B I have an If referenced from an Product

Col A ---- Col B

Week# -- Prod
1 -------- 1
0 -------- 1
0 -------- 1
2 -------- 1
0 -------- 2
0 -------- 2
3 -------- 3
4 -------- 3
0 -------- 3
0 -------- 4
5 -------- 4

Means: Prod 1 = 4 items counted 1 in week 1 1 in week 2 therefore:

Prod 1 = 4 items 2 counted
Prod 2 = 2 items 0 counted
Prod 3 = 3 items 2 counted
Prod 4 = 2 items 1 counted

Expected result: Prod 1 = 50% counted progress
Prod 2 = 0%
Prod 3 = 33%
Prod 4 = 50%

 

[bosco_yip]

Try.........



1] In C2:C5 enter 1,2,3,4, then >> Custom Cell Format, enter : "Prod "0

2] In D2, copied down :

=COUNTIFS(B$2:B$12,C2,A$2:A$12,">0")/COUNTIF(B$2:B$12,C2)

Regards
Bosco

 

[Daniel Valle]

Try.........

View attachment 51165

1] In C2:C5 enter 1,2,3,4, then >> Custom Cell Format, enter : "Prod "0

2] In D2, copied down :

=COUNTIFS(B$2:B$12,C2,A$2:A$12,">0")/COUNTIF(B$2:B$12,C2)

Regards
Bosco

Excelllent....its works

Thank you very much Bosco