Pivot Tables question

D

dziw

I have two colums of data such as:

French / Male
British / Female
Chinese / Child
French /
British / Male
Chinese /
French /
French / Female

I create a pivot table that shows me how many instances of blank (n
data) in column 2 for each item in column 1 (nationality), in this cas
French 2 times, Chinese 1 time.

The question is the way I have it set up I have to un-check (100
lines) all of the instances of male/child/female etc. in order t
leave only the Blank instances. How can I just choose to see only th
blanks rather than un-check 1000 instances of the rest?

Thanks
 
E

Earl Kiosterud

dziw,

You can use COUNTIf for a count of only blanks, something like:
=COUNTIF(B1:B20,"")

Or for a variable-length list, this counts blanks in column B only where
there's something in column A:
=SUMPRODUCT((A2:A65536<>"")*(B2:B65536=""))
I think there's an easier way, but that neuron won't fire this morning.
 
Top