Ask Your Question
0

How to use only visible cells in LibreOffice functions?

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

gulsah gravatar image

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

1 Answer

Sort by » oldest newest most voted
2

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

kompilainenn gravatar image

You can use function AGGREGATE

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

edit flag offensive delete link more

Comments

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

function list doesn't contain any idea about

gulsah gravatar imagegulsah ( 2018-06-27 13:02:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 184 times

Last updated: Jun 26 '18