Ask Your Question
0

Calc: sum cells values having same background color [closed]

asked 2014-04-23 13:38:37 +0200

Franco gravatar image

In Calc I need to sum cells values only if the cells have the same background color.

  • The colors are defined and identify persons
  • Some cells may have the same value but different color (person)

Here you can view an example of what I mean.

Calc - sum by cells background

Thank you for any hint.

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-21 07:13:56.975813

Comments

Thankyou mariosv, this thread [Calc, Basic] Introspective cell functions was helpfull and gave me an effective solution, but I can pass as parameters only absolute cells values (for example CELL_BACKCOLOR(1; 2; 5) indicates $sheet1.$B$5). I want to refer to relative values, for example CELL_BACKCOLOR(1; row(B5); column(B5)) as written in that thread, but this returned a #NAME? error.

Franco gravatar imageFranco ( 2014-04-24 12:31:27 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2014-04-24 01:57:18 +0200

m.a.riosv gravatar image

I think you can find some help in this threads:

Background Color Cell Count.

[Calc, Basic] Introspective cell functions

edit flag offensive delete link more
0

answered 2014-04-24 16:56:05 +0200

Franco gravatar image

updated 2014-04-24 16:58:28 +0200

[SOLVED] This is the right way: [Calc, Basic] Introspective cell functions

I'm using the italian localization of LibreOffice. The correct localized sintax is not

CELL_BACKCOLOR(1; row(B5); column(B5))

but

CELL_BACKCOLOR(1; RIF.RIGA(B5); RIF.COLONNA(B5))
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-04-23 13:38:37 +0200

Seen: 10,945 times

Last updated: Apr 24 '14