use of wildcards
So, if the value I'm looking for is text, why doesn't ISTEXT work in place
of ISNUMBER ?
"italiavb" wrote in message
...
You're a genius man, thanks.
"Biff" wrote in message
...
Hi!
Try this:
=SUMPRODUCT((ISNUMBER(FIND("6-",A1:A4)))*(C1:C4="ok")*(B1:B4="c-25"))
Biff
"italiavb" wrote in message
...
Does anyone know how to use wildcards properly in a formula. For example
(=SUMPRODUCT((A1:A4="6-*")*(C1:C4="ok")*(B1:B4="c-25")). Where "6-*"
would be anywhere the entry in cells A1:A4 begins with the number 6.
|