excel formula

[smannell]

I need a formula that will do the following:

IF E6=X and AE6=X, then count 1 in AI

Thank you in advance for any ideas.

 

[Charlie]

If E6 is a number and AE6 is a number then in A1 enter

=if(and(E6=5,AE6=6),1,"")

If E6 is text and AE6 is text then

=if(and(e6="text",ae6="text"),1,"")

Charlie O'Neill

 

[smannell]

Thank you Charlie.

E6 and AE6 are both text (literally - an "X".)

This formula doesn't return a value at all.

=if(and(e6="text",ae6="text"),1,"")

Any other suggestions?

 

[SMANNELL]

I got it Charlie. I changed "text" to "x". Thanks again.