View Single Post
  #1   Report Post  
0-0 Wai Wai ^-^
 
Posts: n/a
Default countif - Criterion1 OR [Criterion2 AND Criterion3]


I wish to do the following:
=countif(TargetCell or TargetCells, Criterion1 OR [Criterion2 AND Criterion3])

eg: =countif(A1, Criterion1 OR [Criterion2 AND Criterion3])
eg: =countif(A1:A10, Criterion1 OR [Criterion2 AND Criterion3])

How to do?

Thanks.

--
Additional information:
- I'm using Office XP
- I'm using Windows XP