Forum Discussion
How to count blank cells using subtotal
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 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.
Riny_van_Eekelen Extremely helpful, Riny! I don´t know why but I am facing some issues when trying to transform my data into a structured table. Could you please tell me what are the steps to add this subtotal at the end of the table just like you did it? (I also attached the file where I need to add this subtotal)
Thanks a lot!
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!