I am working with a large database in excel. I have to calculate average scores across specific cells. The numerical value in the cells (and by a cell i mean A4, D5 etc.), however, does not correspond to the value that needs to be added by to calculate the score. So far I have been using something like this:

```
=(sum(if(A1=1,3,IF(A1=2,2,IF(A1=3,1,IF(A1=4,0,"NA")))))+
+IF(F1=1,2,IF((F=2,2,IF(F=3,1,IF(F=4,0,"NA")))))+IF(....

```

and so on. Where a cell that contains 1 contributes 3 to the total score, a cell that contains 2 - 2, a cell that contains 3 to 1 etc.

However, I am sure that there should be a quicker and cleaner way of computing this. Is there a way that a similar structure as the one below could be used in excel?

```
for A1,AB1,AC1...[the desired cells); do; 
 if $column=1,3
 if $column=3,1
 if $column=4,0 ; done

```

Thanks for you help in advance!

Best,
R