Find total of blank cells in col F based on named cell in col B

[madforgolf]

Hi guys,
hopefully i have made sense below in my query
I have tried Sumproducts and countifs with no joy.

I have a list of 12 areas of offices in Column B which could have up 70,000 rows. In Column F i have forenames of staff for all office areas.
im trying to find out each area from F:F that does not have a name( or which is blank)
i have tries to use sumproduct, but i dont seem to be able to make it search for blank cells.
also tried to use sumifs and countifs mixed

i can get it to work out all blank cells - but i was hoping to have these broken down into areas.

thanks in advance
Marty

 

[etaf]

would a filter work
just filter on blank

Or are you trying to report only areas that are blank

or a pivot table filtered on page = blank see image below

Book3
	A	B	C	D	E	F
1		AREA	A	B	C	NAME
2		Area1				fred
3		Area2				fred
4		Area3				fred
5		Area4				john
6		Area5
7		Area6
8		Area7				harry
9		Area8
10		Area9				sarah
11		Area10
12		Area11				Jill
13		Area12				fred
14		Area1
15		Area2
16		Area3				john
17		Area4
18		Area5
19		Area6				harry
20		Area7
21		Area8				sarah
22		Area9
23		Area10				Jill
24		Area11				fred
25		Area12
26		Area1
27		Area2				john
28		Area3
29		Area4
30		Area5				harry
31		Area6
32		Area7				sarah
33		Area8
34		Area9				Jill
35		Area10				fred
36		Area11
37		Area12				fred
Sheet1

 

[madforgolf]

Hi etaf thanks for the reply.
i do filter blanks in col F to get only blank info, im trying to make a visual list for other's to see at a glance whats outstanding or blank.

so far i have managed to get the info i need by doing a filter on the col F for blanks then copy and paste this selection into a new sheet, then do the countif on this sheet to get a breakdown. I was hoping i didn't need to do this every time i done a report.

thanks
marty

 

[etaf]

i think i need to see what you mean - I'm not following

Heres is an image of a pivot table - that counts how many names are missing from area
Ie area1 - 4 names missing

 

[madforgolf]

pivot might be the best way to go as others have no ideas how to use excel.

thank you.