Array formula - with OR function returns wrong result

[IanC]

I am trying to calculate the total number of successful installations by
application name.

This consists of one column (K7:K200) with the application name and
another column with completion status (N7:N200).

The completion status can be one of the following 'Successful',
'Anomolies', 'Rejected', 'Backed Out' or blank if it is yet to be
installed.

Only 'Succesful' or 'Anomolies' are classed as successful
installations.

So, I want to calculate the number of incidences of each Application
type where the completion status is either 'Successful' or
'Anomolies''

The formula that I have tried is...(STX is an application)

{=SUM((N7:N200="STX")*(OR(K7:K200="Success",K7:K200="Anomolies")))}

The problem is that the completion status makes no difference to the
final figure. All I am getting is the total number of each application
type regardless of what the completion status is. What am I doing
wrong? Thanks in advance.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((N7:N200="STX)*(((K7:K200="Success")+(K7:K200="Anomalies"))

 

[IanC]

Frank, Thanks that is an improvement but still not quite right.

The results I am getting from that formula are the number of
installations by application that have a completion status of
'Successful' it is not including those with a completion status of
'Anomolies'

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((N7:N200="STX)*(((K7:K200="Success")+(K7:K200="Anomolies"))

0))

Anomolies instaed of Anomalies

Frank

 

[IanC]

Damn, I should have spotted that I suppose! It works perfectly now
Thanks for your hel

 

[Frank Kabel]

Hi
you're welcome
Frank