excel formula

S

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.
 
C

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
 
S

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,"")
Click to expand...
Any other suggestions?
 
Top