Counting Blank cells in a range

[Jackie11]

What forumla would I use to count blank cells in a range?

For example.

A B C
1 1231 - 001 Bill 1/08/2013
2 1232 - 001 Bob
3 1233 - 001 Billy 17/2013
4 1234 - 001 Brad
5
6




How can I count the blank cells in Column C, only if there is data in Column A. Therefore the answer should be '2' because it will exclude row 5 and 6, as there is no data in column A in those rows.

Thanks for the help!

[protonLeah]

For the sample:

Please Login or Register  to view this content.

[wenqq3]

If you records is continuous enter, you can just use countblank(range C), to count blank cell.

if not, then =IF(A1="","",IF(C1="",1,"")), drag to the end. then highlighted the row, to get the sum.

Edited, is col C.

I test protonLeah code, it worked prefect :D

[Jackie11]

Thankyou ProtonLeah! It worked perfectly.

Can I ask another question?

For example:
A B
1 Bill On Hold
2 Bob On Hold
3 - On Hold
4 - Interview
5 - Active

What formula would I use to only count the Names In column A which have ‘On Hold’ In column B??

In this case the answer would be "2".

Thanks