Forum Discussion
Solved
How to count blank cells using subtotal
So, I am trying to find a way to get the completion percentage of different activities. I already found a way to get it the consolidated value (for all groups without filtering), however now I would ...
brunotavares If you transform the your data into a structured table and add a Total row, you can easily do what you need. But you can achieve the same with a regular table and SUBTOTAL, but then you need to enter the formula yourself. Both are demonstrated in the attached file.
brunotavares Sorry but your table is linked to an external link. when I try to add a total row to the table everything turns #VALUE. Can't look at this in detail right now. Sorry!
Don´t worry, Riny! You already helped me a lot, thanks a lot one more time!