Need help with formula
do you mean ...in AL15
=IF(AND(E15="X",ISTEXT(F15)),COUNTIF(D15:AK15,"X") *20,0)
This will return zero if F15 is not text, irrespective of value in E15
And does COUNTIF still want to include E and F as both could be "X"?
"Killer" wrote:
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!
|