Ask Your Question

How to use only visible cells in LibreOffice functions?

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

gulsah gravatar image


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

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

kompilainenn gravatar image

You can use function AGGREGATE

edit flag offensive delete link more


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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 2,065 times

Last updated: Jun 26 '18