How to set a formula to count the product appear how manytime

[AMY]

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

 

[Bob Phillips]

=COUNTIF(A:A,"Product A")

--

HTH

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

 

[amy]

Can I have the countif for 2 or 3 condition together and
hwow to do it

 

[Bob Phillips]

Not COUNTIF, but you can use

=SUMPRODUCT(--(A1:A100="value1"),--(B1:B100=17))

as an example, which counts the number of items where A=value 1 and B =1 7,

Just extend for a 3rd, 4th etc condition, but make sure the range sizes are
always equal.

--

HTH

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