Another Question regarding Multiple Criteria

[enna49]

My apologies if I have repeated myself. As I thought I may have closed off
the question yesterday.

Hi
Following on from this and thank you for your help, is there a way that this
will select in col D all characters except 1 or 2 (eg I would like to
accept everthing except A)

Thanks

Anne

 

[Jacob Skaria]

Try the below
=SUMPRODUCT((B2:B10="QN")*(C2:C10="IM")*(D210<>"")*
(D210<>"A")*(N2:N10<>0))

'if blanks cells in D are to be counted then
=SUMPRODUCT((B2:B10="QN")*(C2:C10="IM")*(D210<>"A")*(N2:N10<>0))

--
Jacob

My apologies if I have repeated myself. As I thought I may have closed off
the question yesterday.

Hi
Following on from this and thank you for your help, is there a way that this
will select in col D all characters except 1 or 2 (eg I would like to
accept everthing except A)

Thanks

Anne

 

[T. Valko]

see your other post

--
Biff
Microsoft Excel MVP

My apologies if I have repeated myself. As I thought I may have closed
off
the question yesterday.

Hi
Following on from this and thank you for your help, is there a way that
this
will select in col D all characters except 1 or 2 (eg I would like to
accept everthing except A)

Thanks

Anne