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

Not sure why you mention a COUNTIF function operating as over a range as
working (but not doing what you want) when your specific question isn't
dealing with a range or counting. Perhaps there is more to this question
than you have stated or I am misreading something here. However, to answer
the question as asked....

=IF(E15="X",IF(F15<"",20*AL15,""),???)

the ??? means I don't know what you want to E15 does not have an "X" in it
at all. If you don't want to do anything, replace the ??? with "".

Rick