Excel data sum
 

I want to add up various responses to a questionnaire by using select rules.
For example if in A2 someone answered 1, I want that to count as 1 point, and
if someone answered 1, I want that to count as 2 points. Anything else would
be a zero. What sort of formula could I use to do that and then add up the
row at the end?

Excel data sum
 

Please clarify the requirement - you said "if in A2 someone answered 1, I
want that to count as 1 point and if someone answered 1 [again - probably
some other value?], I want that to count as 2 points."

But I think a couple of COUNTIF() statements would do, assume your responses
are in A2:A10
=COUNTIF(A2:A10,1)
will give you a count of 1s in the list, and since 1=1 point, no further
work needed.
Assuming that the second entry you want to count is 4 (to help clarify
things), then
=COUNTIF(A2:A10,4)*2
would give you 2 points for each entry of 4 in the list.

If you need total points, you can add them together as:
=COUNTIF(A2:A10,1) + (COUNTIF(A2:A10,4)*2)

IF you have a one-to-one relationship to entry and points, i.e.
1 = 1pt
2 = 2pts
3 = 3pts

Then you could use SUMIF() as
=SUMIF(A2:A10,1) ' would return 4 for four entries of 1
or
=SUMIF(A2:A10,2) ' would return 6 for 3 entries of 2



"Solais" wrote:

I want to add up various responses to a questionnaire by using select rules.
For example if in A2 someone answered 1, I want that to count as 1 point, and
if someone answered 1, I want that to count as 2 points. Anything else would
be a zero. What sort of formula could I use to do that and then add up the
row at the end?