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!

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

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!

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!

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!

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!

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!