How to use only visible cells in LibreOffice functions?

asked 2018-06-26 18:41:06 +0100

28 ●3 ●4 ●8

Hello,

I have a filtered data on a sheet and some formulas uses that filtered column. When i filter that column How can i use only visible cells in libreoffice functions? I need a general answer not for only SUM

image description

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2018-06-26 22:44:57 +0100

kompilainenn

989 ●6 ●16

You can use function AGGREGATE

https://help.libreoffice.org/6.0/en-U...

edit flag offensive delete link

Comments

Thanks for reply but I will use it with COUNTIF SUMPRODUCT COUNTIFS

function list doesn't contain any idea about

gulsah ( 2018-06-27 13:02:50 +0100 )edit

add a comment

Question Tools

1 follower

Stats

Asked: 2018-06-26 18:41:06 +0100

Seen: 2,065 times

Last updated: Jun 26 '18

How to use only visible cells in LibreOffice functions? edit

1 Answer

Comments

Question Tools

Stats

Related questions

How to use only visible cells in LibreOffice functions?