Count and show Formula based on importance?

[TDNova]

Hello,

This might be a very simple question for some of you, but i need help finding the solution.

I got a long row that ive filled inn with information.
at the end of the row i want it to count it up, im open on suggestions here on how to show it.
i was thinking something like this.
5/5 i lack everything
-::-
0/5 i got everything

But i guess this could be shown other ways aswell

I want the one with more importance to count more . If all the important ones are there, its good to go.
but if i have all the mediocre/low and not the important ones, it's not good to go.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 2938"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]HSET-1[/TD]
[TD]HSET-2[/TD]
[TD]HSET-3a[/TD]
[TD]HSET-3b[/TD]
[TD]HSET-6[/TD]
[TD]HSET-7a[/TD]
[TD]HSET-7b[/TD]
[TD]HSET-7c[/TD]
[TD]HSET-7d[/TD]
[TD]HSET-8[/TD]
[TD]HSET-9[/TD]
[TD]HSET-10a[/TD]
[TD]HSET-10b[/TD]
[TD]HSET-10c[/TD]
[TD]HSET-12[/TD]
[TD]HSET-13[/TD]
[TD]HSET-14[/TD]
[TD]HSET-15[/TD]
[TD]HSET-16[/TD]
[TD]HSET-(16a)[/TD]
[TD]HSET-(16b)[/TD]
[TD]HSET-17[/TD]
[TD]HSET-20[/TD]
[TD]HSET-25a[/TD]
[TD]HSET-25b[/TD]
[TD]HSET[/TD]
[/TR]
[TR]
[TD] Important[/TD]
[TD]Important[/TD]
[TD]Important[/TD]
[TD]Important[/TD]
[TD]mediocre [/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] mediocre[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD] low importance[/TD]
[TD]This is were i count how many i got.
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DrShadow]

Hi TDNova,

Why not set a weight on each of the values?

[TABLE="width: 1216"]
<tbody>[TR]
[TD="class: xl76, width: 64"]Weight[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]5[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]3[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[TD="class: xl76, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl76"]Set[/TD]
[TD="class: xl76"]HS1[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS3[/TD]
[TD="class: xl76"]HS4[/TD]
[TD="class: xl76"]HS5[/TD]
[TD="class: xl76"]HS1[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS3[/TD]
[TD="class: xl76"]HS4[/TD]
[TD="class: xl76"]HS5[/TD]
[TD="class: xl76"]HS1[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS2[/TD]
[TD="class: xl76"]HS3[/TD]
[TD="class: xl76"]HS4[/TD]
[TD="class: xl76"]HS5[/TD]
[/TR]
[TR]
[TD="class: xl76"]Data[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]High[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Medium[/TD]
[TD="class: xl76"]Low[/TD]
[TD="class: xl76"]Low[/TD]
[TD="class: xl76"]Low[/TD]
[TD="class: xl76"]Low[/TD]
[TD="class: xl76"]Low[/TD]
[TD="class: xl76"]Low[/TD]
[/TR]
</tbody>[/TABLE]

Example above.... then do a countIF formula, and if you have reached a limit of lets say 25 then you are good to do as per your pexpression?

just a thought ofc.

 

[TDNova]

Hello DrShadow!

Ive never tought about it since im very new.

But indeed that sounds like a solid plan, i need to find some guides on how to use it.
Im willing to give it a shot.

Thanks for the headsup!

 

[TDNova]

Hello, i was testing DRshadow's idea, it could work on a smaller scale with less variation.

But the problem on the database i have is that there is diffrent amount for each type " would require alot of tweaking".

Im trying to make it work like this =

If the first 4 cells do not contain value then its red for warning(important parts that is a must) If you have the first 4 then it's okey. but i still want to count the other ones aswell.
Im not sure how to make the first 4 cells count more than the others.

[TABLE="width: 1008"]
<tbody>[TR]
[TD]TGX-1[/TD]
[TD]TGX-2[/TD]
[TD]TGX-3[/TD]
[TD]TGX-4[/TD]
[TD]TGX-5[/TD]
[TD]TGX-6[/TD]
[TD]TGX-7[/TD]
[TD]TGX-8[/TD]
[TD]TGX-9[/TD]
[TD]TGX-10[/TD]
[TD]TGX-11[/TD]
[TD]TGX-12[/TD]
[TD]TGX-13[/TD]
[TD]TGX-14[/TD]
[TD]TGX-15[/TD]
[TD]TGX[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] 80%


[/TD]
[/TR]
</tbody>[/TABLE]
It does not need to be %, it could be with color or both
This is just and example. if you need more information info just ask.