Count Cells With Blank Contents

[maheshr68]

Greetings!!

Need your quick assistance in this..

Input Data -


ColA ColB ColC
Site1.com 7/13/2011
Site2.com 7/13/2011
Site3.com 7/13/2011
Site4.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site1.com 7/13/2011
Site1.com 7/13/2011
Site1.com 7/13/2011
Site6.com 7/13/2011
Site4.com 7/13/2011 7/13/2011
Site6.com 7/13/2011
Site6.com 7/13/2011
Site3.com 7/13/2011
Site3.com 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site4.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site1.com 7/13/2011
Site4.com 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011
Site5.com 7/13/2011 7/13/2011


Expected Result-


Total ColA_Count Rows_with_Blank_Entries_in_ColC
Site1.com 5 5
Site2.com 1 1
Site3.com 3 3
Site4.com 4 1
Site5.com 16 0
Site6.com 3 3


Seeking your valuable solution..

Best Regards,
Mahesh

 

[VoG]

Try

Excel Workbook
	A	B	C	D	E	F	G
1	Site1.com	7/13/2011			Site1.com	5	5
2	Site2.com	7/13/2011			Site2.com	1	1
3	Site3.com	7/13/2011			Site3.com	3	3
4	Site4.com	7/13/2011	7/13/2011		Site4.com	4	1
5	Site5.com	7/13/2011	7/13/2011		Site5.com	16	0
6	Site5.com	7/13/2011	7/13/2011		Site6.com	3	3
7	Site5.com	7/13/2011	7/13/2011
8	Site1.com	7/13/2011
9	Site1.com	7/13/2011
10	Site1.com	7/13/2011
11	Site6.com	7/13/2011
12	Site4.com	7/13/2011	7/13/2011
13	Site6.com	7/13/2011
14	Site6.com	7/13/2011
15	Site3.com	7/13/2011
16	Site3.com	7/13/2011
17	Site5.com	7/13/2011	7/13/2011
18	Site5.com	7/13/2011	7/13/2011
19	Site5.com	7/13/2011	7/13/2011
20	Site5.com	7/13/2011	7/13/2011
21	Site5.com	7/13/2011	7/13/2011
22	Site4.com	7/13/2011	7/13/2011
23	Site5.com	7/13/2011	7/13/2011
24	Site5.com	7/13/2011	7/13/2011
25	Site5.com	7/13/2011	7/13/2011
26	Site5.com	7/13/2011	7/13/2011
27	Site5.com	7/13/2011	7/13/2011
28	Site1.com	7/13/2011
29	Site4.com	7/13/2011
30	Site5.com	7/13/2011	7/13/2011
31	Site5.com	7/13/2011	7/13/2011
32	Site5.com	7/13/2011	7/13/2011
Sheet5

 

[maheshr68]

Greetings!! VoG,

That was really fast and perfect!! .. Thank You..

Best Regards,
Mahesh