Counting cells that does not contain

[JODomingos]

Hello Friends!
I have been trying to create a formula to count how many cells in the row with specific text content that is different of reference(Column EA and EB).
For instance below: second line my reference is G and T, then I would like to count only cells that does not have those content G and T(Yellow cells) and fill the result in column EC.

Can you help me?

 

[Peter_SSs]

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Does this do what you want? (You may need to confirm with Ctrl+Shift+Enter, not just Enter)

20 09 14.xlsm
	DV	DW	DX	DY	DZ	EA	EB	EC
1
2	TT	TA	TT	TA	TT	G	T	2
3	GC	GG	GG	GG	GG	A	G	1
4	AA	AA	AT	AT	AA	A	C	2
5	TT	TC	TC	TC	TT	G	T	3
Count

Cell Formulas
Range	Formula
EC2:EC5	EC2	=COUNTA(DV2:DZ2)-COUNT(-SUBSTITUTE(SUBSTITUTE(DV2:DZ2,EA2,1),EB2,1))