Hello,

I have this formula-

=IF(AND(OR(H2='Flight - RPET'!$Y$7),C2='Flight - RPET'!$Y$8),COUNT(M$1:M1)+1,"")

It's reading the word RPET from a seperate sheet and finding all references to RPET.

Is it possible to make the formula ignore cells that have '800' in them?