Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |