Hi,

In 2007 you could use

=COUNTIFS(A1:A100,"Weymouth",B1:B100,"<")

instead of

=SUMPRODUCT((A1:100="Weymouth")*(B1:B100<""))

And if you entered Weymouth in F1 then both formulas would be more dynamic.

=COUNTIFS(A1:A100,F1,B1:B100,"<")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hayleyho" wrote:

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!!