View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Countif with 2 Conditions

.. my data has only one column and i have to apply multiple condition.

Maybe you meant something like this:
=SUMPRODUCT((COUNTIF(A2:A10,{"kk","gg","aa"})))
which counts the total occurrences of: kk, gg, aa
within the range A2:A10
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---