View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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!