recognize any character as oppossed to x

[RodneyW]

I currently have this formula in a cell. It requires people to enter x for the calculation to take place. How can I change it so it will calculate as long as any character is entered into the cell?


=SUMPRODUCT(--(Q7:T7="x"),CHOOSE({1,2,3,4},E7,H7,K7,N7))

TY in advance

 

[RoryA]

Replace ="x" with <>"" instead.

 

[Fluff]

How about
=SUMPRODUCT(--(Q7:T7<>""),CHOOSE({1,2,3,4},E7,H7,K7,N7))

 

[RodneyW]

Worked perfectly, thanks

 

[Fluff]

Glad we could help & thanks for the feedback