Hai,

Need a sugestion from you all. I have problem to count my data. For example,
I want to count for each Team how many coaching or counseling had been done.

ColumnA .....ColumnC
TEAM Action
Level 1 Coaching
Level 1 Coaching
Level 2 Caunseling
Level 3 Counseling
Level 2 Coaching
Level 3 Coaching
Level 1 Counseling

I tried using this formula, but it giving me all result as 1

=COUNT(IF((A2:A11="Level 1")*(C2:C11="Coaching"),C2:C11))

And when I tried this formula, the result will be 0

=SUM(IF(A2:A11="Level 1",IF(C2:C11="Coaching",1,0)))

Please help.
--
Thanks! =)