Count blank cells when the data base is filtered

[Arup Dutta Chowdhury]

I have got a database in which Item wise some cells contains numeric figure and some cell is blank. Now I want to count the blank cells Item wise means if filter the database item wise the result of blank cells will get changed. I have the attached the file. Please help.

 

[kchiba]

Hi Arup,

not sure what you want counted, do you want to count the number of blank cells in the whole table, the number in a certain column.

So if you put the following in D65 it will tell you there are 33 blank cells in the column D

=COUNTIF($D$3:$D$64,"")

 

[Arup Dutta Chowdhury]

No I don’t want this result. Let me rephrase what result I want. Please look at the description column it contains several items. Now if I filter the data item wise I want to see the number of blank cells from January to November. For Example If I filter and select Coke 1.25 it will show the number of blank cells now if I filter and select coke 2 RGB the result of the number of blank cells will get changed automatically. Like this I want the result. Hope you have understood. Please reply.

 

[kchiba]

Arup

in A1 enter the following:


=96-AGGREGATE(2,5,$D$3:$CU$64)

 

[Abhijeet R. Joshi]

If you have a static data in Col.A and varying data in Col.B so you can use the below:

=SUBTOTAL(3,A2:A13)-SUBTOTAL(3,B2:B13)

{change the range as desired}