CountIf
 

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.

CountIf
 

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.

CountIf
 

=SUMPRODUCT(--(Store_Range="Store1"),--(Amount_Range=0))

if there are any blanks involved in the amount range and if they shouldn't
be counted as zero

=SUMPRODUCT(--(Store_Range="Store1"),--(ISNUMBER(Amount_Range)),--(Amount_Ra
nge=0))


--

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.