Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
I may not have understood but here goes, in AL15 try:-
=IF(AND(E15="x",ISTEXT(F15)),"*20","") What I think you may be asking is if E15=x and there is text in F15 multiply the contents of AL15*20. If you are saying that you can't do it. A formula can only alter the cell it is wtitten in, Mike "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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
I'm reading this differently than the others.
Something like this: =SUMPRODUCT(--(E15:K15="x"),--(F15:L15<""))*20 But, why does your formula reference D15 yet you're asking about E15 and F15? Biff "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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula
Thanks guy for the great help you all are awesome and I'll try to be clearer
next time. "T. Valko" wrote: I'm reading this differently than the others. Something like this: =SUMPRODUCT(--(E15:K15="x"),--(F15:L15<""))*20 But, why does your formula reference D15 yet you're asking about E15 and F15? Biff "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|