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)
"amy" wrote in message
...
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
.
|