View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Counting multiple values (including blanks) in one column

Paul,

As David explained, an OR is required, expressed indicatively as:
((Cond1)+(Cond2)+(Cond3)+...)

Hence the part in your expression should look like this:
.... *(('Grid data'!F2:F4557="NS")+('Grid data'!F2:F4557="C")+
(TRIM('Grid data'!F2:F4557)="")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---