We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Sumproduct() of a specified row of an array. [closed]

asked 2020-04-18 20:52:18 +0200

jameskuyper gravatar image

updated 2020-07-28 20:47:20 +0200

Alex Kemp gravatar image

j9:bm17 contains an array, and $BQ1 contains the number of a row in that array. I want to compute the sumproduct of that row with j24:BM27. My best guess so far was:


but that produces an error message saying "wrong data type". How can I do this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-28 20:47:46.055132


hi James, check that there are no string characters within any of the selected cells also the cell format should be numeric not alpha-numeric

uglybug gravatar imageuglybug ( 2020-04-18 22:41:27 +0200 )edit

If the tip from uglybug does not lead to a solution, check also that the value in BQ1 is numeric, and in the range 1-9. If you select that cell and it shows a leading apostrophe in the formula field, the number is entered as text.

If it is a formula, perhaps share that formula with us.

keme gravatar imagekeme ( 2020-04-19 00:21:32 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-19 13:17:01 +0200

Steph gravatar image

I have built a spreadsheet reproducing your layout and it is working fine for me. I am using Calc under Windows10.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-04-18 20:52:18 +0200

Seen: 74 times

Last updated: Apr 19 '20