First time here? Check out the FAQ!
I have two columns : first one for incomes et second for people. I activated the auto-filter thus I can display all incomes for a particular person. (see attached C:\fakepath\subtotal-example.ods).
My question : I tried to use the subtotal function to track the total amount of incomes for each person...but as soon as my display filter parameters change, the subtotal change :o(
Do I use the subtotal function the wrong way or simply misunderstood it ? and above all, how would you achieve this goal (total based on display filter results)
Thank you !
answered 2012-10-13 02:02:09 +0200mariosv
Because SUBTOTAL() works taking only the visible cells.
You can use SUMIF() to get what you want. =SUMIF($B$1:$B$8;"brigitte";$A$1)
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-12 23:44:25 +0200
Seen: 131 times
Last updated: Oct 13 '12