Rita wrote...
I think I need to be more specific.

Indeed.

This is to compile information from questionaires for job postings. Column E can be
either yes or no and we want a point (either zero or 2) in column F, column G can
have any of the following anwers; none (zero pts), 1-2 years (2 pts.), 3-5 years
(4 pts.), 6+ years (6 pts). . . .

I'll assume row 5 for example formulas. For col E,

=IF(E5="Yes",2,0)

For col F,

=LOOKUP(F5,{0;1;3;6},{0;2;4;6})

Then column H is for those points to be filled in.

Meaning the formula in H5 should be the sum of the points from the
answers in E5 and F5? If so, H5 should be

=IF(E5="Yes",2,0)+LOOKUP(F5,{0;1;3;6},{0;2;4;6})

The last two columns are repeated for several different questions. . . .

Unclear.

Repeated how?

Do you mean there are answers for different questions in columns E and
F in additional rows, or are, say, columns J and K used for another
pair of answers with corresponding points in column M, and columns O
and P for another pair of answers with corresponding points in column
R, etc?

Then at the end there is a Total column that all the points in each row would be added up.
....

This makes it seem like the latter - multiple groups of 4 columns
(with blank columns between groups of answers and corresponding
points) all on the same row. If so, and the points were in every 5th
column, so in columns H, M, R, W, AB, AG, AL, etc, then the total
points for a row could be calculated using the formula (again row 5)

=SUMPRODUCT(--(MOD(COLUMN(H5:AL5),5)=3),E5:AL5)