What happens if E15 has *no* "X", and F15 *does* have text?

Try this for the conditions you stated ... not for what you didn't say!

=(AND(E15="X",ISTEXT(F15)))*COUNTIF(D15:AK15,"X")* 20

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Killer" wrote in message
...
I have this formula and it works but doesn't meet my requirements. The
result
is entered into column AL15

=COUNTIF(D15:AK15,"X")*20

I need it to read two columns every time before giving the results in
column
AL15

If column E15 results X and text is entered into column F15 the result
should be *20 in column AL15 if E15 results in X and no text is entered
into
column F15 the result should be nothing added into Column AL15


Thanks ahead!