Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not entirely sure how your data looks, but may be like attached
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