Hi there, I have a question that has been driving me nuts so if anyone can
assist, it would be much appreciated.
My spreadsheet looks like

A B
C
1 Weymouth 6/5/09 5/9/06
2 Dorchester 12/1/09 3/2/04

What I want to be able to do, is to say, "if A1 equals weymouth, and B1 is
not blank, count it".

Any ideas? Solving this will make a currently long winded manual counting
process take seconds for me at work. Any help appreciated!!