CountIf

J

Jim

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

Peo Sjoblom

=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))
 
Top