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