countif values within table

[#1]

Hi

i would like to know if there's a way to count values in different cells

like this Example in excel

COUNTIF(I6:M6, 2)*5+COUNTIF(I6:M6, 1)*1

if there's a value '2' in range count it and multiple by 5

if there's a value '1' in range count it and multiple by 1

A	B	C	D	E	Score
0	0	0	2	1	6
0	0	0	2	1	6
0	0	1	0	2	6
0	1	0	0	2	6
0	2	1	0	0	6
0	0	2	0	0	5
0	0	2	0	0	5
0	0	0	2	0	5

i want to use it on straight / pivot table

TNX

Ariel

[sunny_talwar]

Not entirely sure how your data looks, but may be like attached

[#3]

Thanks Sunny

unfortunately i working now with personal addition so i can't open the file

can you please write how you solved it

my data is on  straight table i have 4 dimensions and the expressions is looks like the table above

i want to add another column (SCORE)  that calculate according to the values of the expressions in every row

COUNTIF(I6:M6, 2)*5+COUNTIF(I6:M6, 1)*1

thanks again for your help