COUNTBLANK formula

[TC123]

Hello,

I was wondering if somebody could possibly help me? In Column C of my spreadsheet I need to count all of the blank cells and then times them by 2. This is fine and it worked with the formula =(COUNTBLANK(C425:C452)*2.
However, I now have hidden some rows (I cannot delete these rows as I may need to bring them back at some point). When I apply this formula it is still counting in the hidden rows. Can somebody please tell me how I would get this formula to just count the unhidden rows (i.e C425:C430,C437:C439,C446:C448, C450:C452).
Thank you

 

[TC123]

bump*

 

[Expiry]

Can you use the same criteria that you use to choose whether to hide a row or not?

Ie. If you're hiding all rows with "Paid" in Col A (for example), you can then count all the ones that aren't Paid and have a blank in col C.

 

[TC123]

Thank you for the reply but not really. The spreadsheet is a number of questions for an audit and the questions I have hidden are ones they are not using for this month. So the questions I've hidden are all different with nothing in commom unfortunately

 

[Expiry]

If you're hiding them individually, manually, you could create a column and just put an x in all the ones you want to hide, then hide those with an x.

Then you can count the ones that don't have an x and are blank in col C.

I think the only alternative is to use VBA.