Can I use sumproduct in numbers?

that is the incorrect syntax for sumproduct(). You can get function help by typing the "=" sign in any cell then enter the function name (or just a few letters):

Information from this help:

The SUMPRODUCT function returns the sum of the products of corresponding numbers in one or more collections.

SUMPRODUCT(range, range…)

• range: A collection of cells. rangecontains a reference to a single range of cells containing number values orduration values. If all values are duration values, SUMPRODUCT returns a number value. If one and only one cell in rangecontains a duration value while all others contain number values, SUMPRODUCT will return a duration value. If string values or boolean values are included inrange, they are ignored. If date/time values are included in range, SUMPRODUCT will return an error.
• range…: Optionally include one or more additional collections of cells. The collections must all have the same dimensions.

Notes

The SUMPRODUCT function multiplies the corresponding numbers in each collection and then sums each of the products. If only one collection is specified, SUMPRODUCT returns the sum of the collection.

I suspect there is another way but without more context it will be hard to provide a specific solution. Post a screen shot without name, please.

Wayne,

I had the same initial impression: surely this must be incorrect syntax. But it is indeed a valid formula in Excel! I pasted it in and tried it out. I *think* (though I haven't had time to investigate) that it may be a form of array formula, and of course Numbers can't handle array formulas the way Excel can.

What it produces in Excel is a count of the matches between a value in C6:AO6 and the corresponding value in the same column in C3:AO3. Presumably C2:AO3 contains the answer key and C6:AO6 contains the actual answers.

I was trying to think of formulas to count occurrences of either of two correct values (the Excel formula seems to check against one correct answer for each question), and I came up empty. Any ideas on how to do that with formulas?

SG

And example using the "--" in Excel's SUMPRODUCT here. Maybe some clues there on what it does and how to produce similar in Numbers.

SG

There are 2 correct answer for each question. I would like to give a point for each correct answer.

Since SUMPRODUCT can't be an array function in Numbers, I think you need a less compact approach such as this one:

The 'Answer Key' and 'Answers' tables hold input data. The question numbers are across the top.

The formula in D2 of the 'Scores' table, copied right and down, is:

=COUNTIF(Answer Key::D,Answers::D2)

The formula in B2, copied down, is:

=SUM(2:2)

Columns A and B are defined as Header Columns before entering the formula in column B.

SG