Ask Your Question
0

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:

=SUMPRODUCT(INDEX($J$9:$BM17,$BQ1),$J27:$BM27)

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

Comments

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
0

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 6.4.2.2. under Windows10.

C:\fakepath\Sumproduct.ods

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 35 times

Last updated: Apr 19