Hi guys,
I want to count a total of specific value depended on what i have entered.
So for example
SV9F
SV9F
SV9F
SV9H
I want to count the totals on that column. But i want the formula to be able to know that SV9F is "1" and SV9H is "0.5" so it would return a count of 3.5 instead of 4.
Any suggestions?
Thank you
I want to count a total of specific value depended on what i have entered.
So for example
SV9F
SV9F
SV9F
SV9H
I want to count the totals on that column. But i want the formula to be able to know that SV9F is "1" and SV9H is "0.5" so it would return a count of 3.5 instead of 4.
Any suggestions?
Thank you