Hi Bob,

tried to access your site a few times recently and am told "The domain
xldynamic.com has expired". I then get put through to Xldynamic.com -
totally different. What's happening? Are you aware of this?

Pete

On Mar 28, 10:44*am, "Bob Phillips" wrote:
=SUMPRODUCT(--(ISNUMBER(SEARCH("HQ BLNG",DREGION)))+
* * * * * * * * * * * * * * (ISNUMBER(SEARCH("TRANSPORT",DREGION)))+
* * * * * * * * * * * * * * (ISNUMBER(SEARCH("FREIGHT",DREGION))),MISDUE)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Eddy Stan" wrote in message

...



Hi
Can anyone help me on this. thanks in advance.
I am getting answer required by the following formula
=SUMPRODUCT(--(DREGION="HQ BLNG EAST")+(DREGION="HQ BLNG
WEST")+(DREGION="HQ
BLNG NORTH")+(DREGION="HQ BLNG SOUTH"),MISDUE)
Where the first part is constant "HQ BLNG".
Is there any way to search the string in range DREGION and find the sum.
Like "HQ BLNG xxxx", "xxxx TRANSPORT xxxx", "xxxxx xxxxx FREIGHT"
xxxx i mean to say that it could be any string.

Thank you- Hide quoted text -

- Show quoted text -