COUNTBLANK formula

TC123

New Member
Joined
Dec 14, 2010
Messages
32
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Expiry

Well-known Member
Joined
Jun 20, 2007
Messages
865
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

New Member
Joined
Dec 14, 2010
Messages
32
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

Well-known Member
Joined
Jun 20, 2007
Messages
865
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,995
Messages
5,856,705
Members
431,828
Latest member
kARTIK12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top