Ask Your Question

Column Label in a SUMIFS function gives an Err:502 [closed]

asked 2014-03-08 06:42:03 +0100

yvnicolas gravatar image

updated 2015-09-11 12:32:26 +0100

Alex Kemp gravatar image

I am struggling with a strang Err :502. The following function =SUMIFS('Net';'Compte';$D$2;'Rentree';"<="&F4) results in a Err:502 on one spreadsheet and not an another with column labeled exactly the same. If I replace in the formula the column labels by actual cell range references (ie D10:D1000), the formula works fine.

Any idea where it might comme from?

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 2016-02-20 06:40:25.193782

2 Answers

Sort by » oldest newest most voted

answered 2014-03-08 15:14:19 +0100

m.a.riosv gravatar image

updated 2014-03-08 15:16:20 +0100

Please @yvnicolas, verify if you have the labels range defined in Menu/Insert/Names/Labels

image description

edit flag offensive delete link more

answered 2014-03-10 00:01:57 +0100

Regina gravatar image

Calc has the feature of auto detecting column or row labels. It is set in Tools > Options > Calc > Calculate. This setting is stored in the document. So perhaps it is enabled in one document and not in the other?

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-03-08 06:42:03 +0100

Seen: 692 times

Last updated: Mar 10 '14