Ask Your Question

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

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

yvnicolas gravatar image

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

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 +0200

m.a.riosv gravatar image

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

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 +0200

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 +0200

Seen: 648 times

Last updated: Mar 10 '14