Ask Your Question
0

Help with SUMPRODUCT formula [closed]

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

tatizanon gravatar image

updated 2020-07-28 20:58:59 +0200

Alex Kemp gravatar image

Hi,

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.

=SUMPRODUCT($Database.$AD$2:$AD$2800,"-",$Database.$AE$2:$AE$2800,"x")

Can you help me?

Thanks, Tatiana

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:59:37.776003

2 Answers

Sort by » oldest newest most voted
1

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

JohnSUN gravatar image

I think you mean

=SUMPRODUCT($Database.$AD$2:$AD$2800="-";$Database.$AE$2:$AE$2800="x")

(not comma, but equal sign)

edit flag offensive delete link more
0

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

Stats

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

Seen: 4,455 times

Last updated: Sep 19 '13