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.

You already got 2 answers to your earlier post

--

Regards,

Peo Sjoblom

"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.

However your answers did not work, so I reposted for more input

"Peo Sjoblom" wrote:

You already got 2 answers to your earlier post

--

Regards,

Peo Sjoblom

"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.