Show count of a cell either using colour or wildcard lookup?

[excelnoob_67]

Hi All,

See my table test data.
I want to show a total based on the cells that are <> Not in Scope.
However I want to exclude OS Upgrade Status from the formula, so those cells do not add to the count.
Any of the cells that have a DNS listed are highlighted green if that helps, but can not be filtered.

Formula has to be in actual table qty and counted on the same row

Thanks in advance

Actual Table QTY	Tablet DNS Name TW101	OS Upgrade Status	Tablet DNS Name TW102	OS Upgrade Status	Tablet DNS Name TW103	OS Upgrade Status
Formula HERE	SV7841TW101		Not in Scope		SV7841TW103
	Not in Scope		SV0545TW102		SV0545TW103
	SV7762TW101		Not in Scope		SV7762TW103
	SV0613TW101		SV0613TW102		Not in Scope
	SV5804TW101		SV5804TW102		SV5804TW103
	SV7705TW101		SV7705TW102		SV7705TW103
	Not in Scope		SV7703TW102		SV7703TW103
	SV0667TW101		SV0667TW102		SV0667TW103
	Not in Scope		SV0585TW102		SV0585TW103
	SV0654TW101		SV0654TW102		SV0654TW103
	SV0523TW101		SV0523TW102		SV0523TW103
	Not in Scope		SV0506TW102		Not in Scope
	SV0630TW101		SV0630TW102		SV0630TW103

 

[Peter_SSs]

See if this does what you want

=COUNTIFS(J$1:BP$1,"Tablet*",J3:BP3,"<>Not in Scope",K$1:BQ$1,"*Status",K3:BQ3,"<>Not Found")

 

[excelnoob_67]

Looks thanks really appreciate it!!!

 

[Peter_SSs]

Cheers