Google Sheets: Exclude Hidden or Filtered Rows in your Formula (SUBTOTAL FUNCTION)

[@WorkflowWisdom]

✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

[@isaak1904]

Thank you for sharing

[@WorkflowWisdom]

My pleasure

[@Allen-L-Canada]

that was a cool function

[@WorkflowWisdom]

Great to hear you liked it.

[@afvejlani]

Hi.. Can you show the function to serialize the number excluding the hidden rows in google sheets?

[@WorkflowWisdom]

As I've already mentioned in the video, if you want to exclude hidden cells, just write the function code then prepend it with 10. In the example, that would be 10 then 9, so your formula would be SUBTOTAL(109,[range]). Hope this explains it.

[@afvejlani]

​@@WorkflowWisdom thank you so much.. it helped. Your expectations are much easier.

[@WorkflowWisdom]

Glad it helped.