Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorry, another question....

Status
Not open for further replies.

kdr1974

IS-IT--Management
Jul 18, 2008
13
GB
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
 

EDIT - I have now got the scores I need by using the IF command, if there is no score I get a FALSE message (which is fine), how do I add the scores that I do have, doing a SUM always returns a nil value - is this because there is text in there as well?
 
Getting FALSE isn't fine... I suspect you didn't include a "value if false" argument in your IF function.

Also, the FALSE should just be ignored by the SUM function. It isn't causing your "nil" values. (What do you mean, anyway; is the result 0?)

Also, you didn't supply any examples, but it sounds to me like what you want is SUMIF. Something like this:

=SUMIF(B1:B20,"x",C1:C20)

--Lilliabeth
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top