Thread: subtotal blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
  
Posts: 70
Default subtotal blank cells
I am wanting to count blank cells when using filters. I have tried
=subtotal(9,=countblank(A1:A500)) but it will not accept this formula.

Is there anyway I can do this?
Reply With QuoteReply With Quote