Try this, Jim:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"Jim" wrote in message
...
Hello,

I am trying to figure out a countif formula. Here is the explanation:

Worksheet one (my data dump page): In column A I have store names listed.
In column B I have the amount of each sale for that store.

Worksheet two: In column A I have the store names listed. In column B I
would like to have a count of $0.00 sales made for each store. The data
on
the first sheet shows $0.00 sales as 0.

Thanks for the help.