Need help with formula

K

Killer

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!
 
R

Rick Rothstein \(MVP - VB\)

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
 
M

Mike H

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
 
T

Toppers

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"?
 
R

Ragdyer

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
 
T

T. Valko

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
 
K

Killer

Thanks guy for the great help you all are awesome and I'll try to be clearer
next time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top