Ask Your Question

Help with SUMPRODUCT formula [closed]

asked 2013-09-19 15:40:24 +0200

tatizanon gravatar image


I use LibreOffice 3 and I'm trying to use SUMPRODUCT in substitution to COUNTIFS, but I get #VALUE! error. I looked for other answers in similar questions and my formula appears to be ok, but I don't know why I get error.


Can you help me?

Thanks, Tatiana

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 04:11:59.657942

2 Answers

Sort by » oldest newest most voted

answered 2013-09-19 18:10:32 +0200

JohnSUN gravatar image

I think you mean


(not comma, but equal sign)

edit flag offensive delete link more

answered 2013-09-19 17:52:14 +0200

L-user gravatar image

updated 2013-09-19 18:05:39 +0200

Don't know what are you trying to accomplish, but sumproduct function is using two or more arrays that are multiplied. Sample:

image description

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-19 15:40:24 +0200

Seen: 4,085 times

Last updated: Sep 19 '13