View Single Post
  #3   Report Post  
amy
 
Posts: n/a
Default

Can I have the countif for 2 or 3 condition together and
hwow to do it
-----Original Message-----
=COUNTIF(A:A,"Product A")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AMY" wrote in

message
...
Hi all,

Really need your help on how to set a formula to count

the
product name appear in how many time.

example,

Cell A1
Product A
product B
Product C
Product A
Product A
product B

total product A = 3 times
total product B= 2 times
total product c = 1 times

thanks for help





.