Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to use the Countblank formula in conjuction with the Auto Filter
Function. Let me try and explain. I have data listed in date order in colum e; and in column F I have the date which I have tested the data. ANyway not that that information matters. I want to be able to select a date in column E using the auto filter feature and want to use the CountBlank formula to count how many blank cells show up in column F. The problem is, the CountBlank formula counts all the blanks in that column. So I think what I need is something similar to the Subtotal function you use to total columns hen using the sutofilter, only I need it to count the blank cells. Does anyone have any idea how I can do this? Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |