|Unless you want to do this with VB/VBA, you're probably better off posting this in the office forum. However:|
If I understand correctly, you're trying to get a count of how many rows have "Old" in column A, and do NOT have a blank in either column B or column C.
If this is right, try:
Hope this helps