Ask Your Question
0

Help with SUMPRODUCT formula [closed]

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

tatizanon 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 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
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,085 times

Last updated: Sep 19 '13