Hi all
I am also trying to write a questionnaire. Ideally people will put an X in one cell to indicate their preference. Each answer will then have a score. How do I SUM on the condition that one cell has an X in it and the adjacent cell has the relevant number, is it something like COUNTIF and then the two conditions?
Thanks
Kyle
I am also trying to write a questionnaire. Ideally people will put an X in one cell to indicate their preference. Each answer will then have a score. How do I SUM on the condition that one cell has an X in it and the adjacent cell has the relevant number, is it something like COUNTIF and then the two conditions?
Thanks
Kyle