Column A of my worksheet has a bunch of part numbers. Columns B and C have
formulas that show quantities based on data coming from other worksheets via
a link.
What I would like to do, is put a formula in cell D1 that counts all the
records based on the following criteria:

If the cell in Col. A is not blank, and if the quantities in both Cell B and
C are equal to zero, then count that record.

So, I created the following formula (which obviously does not work...):
=countif(a:a,and(a<"",and(b="0",c="0")))

I am looking for a dynamic formula that will work no matter how many records
are in Cols A,B,C.

Thanks.
--
tb