Order of Operations  PEMDAS syntax
Hello, I am currently designing a Quiz, but I am having an issue with my syntax and I was hoping someone could explain what I'm doing wrong. Basically, I have a test that is worth 208 total points.
Let's say that there are 84 questions and each question is worth 1, 2, 4, or 6 points.
Here is where the twist comes in. Sometimes the answer to a question will be "N/A". So for example, if there is one N/A answer on a question that is worth 2 points, I need the the total to shift from 208 to 206 total points.
What I currently have done is have N/A be worth the inverse of a full credit. So if a question was worth 2 points if they are correct, I would have the N/A value be 2. Then I have 2 helper columns to run a SUMIF. Helper column 1 sums up all the number values above 0, and then Helper column 2 sums up all the number less than 0 and then multiplies it by 1 to get a positive value.
Then my result column basically: Helper Column 1 / (208  Helper Column 2). This works, but I was wondering if there was a way to rewrite it so I didn't have to use 2 additional helper columns
=(SUMIF([Data Range], > 0) / (208  ((SUMIF([Data Range] < 0) *1))
However, I keep getting a syntax error. Am I missing something or is this a smartsheet limitation?
Answers

Hi @Dan B.
Is this the formula copied directly from your cell:
=(SUMIF([Data Range], > 0) / (208  ((SUMIF([Data Range] < 0) *1))
If so, I think your syntax error is caused by this part: [Data Range]
If Data Range is the column name, to SUM the entire column, you would use [Data Range]:[Data Range]
If it is a cross sheet reference to a column in another sheet it would be {Data Range}

Sorry for the delay on it, but it's [Data Range]@row:[Data Range]@row
The way my sheet is set up is that each column is an "answer" and the column next to it is a "point value". The answers are text, the point values are number values.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!