If you mean count the number of times Column X contains 'Success' or
'Failure', try...

=SUMPRODUCT(--(ISNUMBER(MATCH(Sheet1!$X1:$X5809,{"Success","Fail ure"},0))
),--(Sheet1!$AJ1:$AJ5809=SUCCESSFULRes!$A2))

Hope this helps!

In article ,
vect98 wrote:

=SUMPRODUCT(--(Sheet1!$X1:$X5809="SUCCESS"),--(Sheet1!$AJ1:$AJ5809=SUCCESSFULR
es!$A2))


I want to add another condition to this so its for success and failure.
Ive tried copying the first part and adding it and also tried putting an
AND condition in but it still wont worked.

TIA :)