Another Question regarding Multiple Criteria

  • Thread starter Thread starter enna49
  • Start date Start date
E

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
 
Try the below
=SUMPRODUCT((B2:B10="QN")*(C2:C10="IM")*(D2:D10<>"")*
(D2:D10<>"A")*(N2:N10<>0))

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

--
Jacob


enna49 said:
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
Click to expand...
 
see your other post

--
Biff
Microsoft Excel MVP


enna49 said:
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
Click to expand...
 
Back
Top