B

#### BeSmart

I'm having trouble with a couple of formulas and I think I've written them

wrong??

First Formula:

In cell CB183 the formula looks at range($B$37:$H$165) to finds any

occurrences of "production"or "installation" or "non commission" within any

STRING of text (hence the "*XX*") and then adds those rows in

range(CB37:CM165) that match.

{=SUMPRODUCT(--ISNUMBER(SEARCH({"*production*";"*installation*";"*non

commission*"},$B$37:$H$165)))*CB37:CM165)}

The formula works when I type "production" into any cell within the

range(B37:G165), but it doesn't work if I type the word "installation" or

"non commission" into any cell in the range?

Could someone tell me what I've done wrong here??

Second problem:

I'm getting a circular reference error from the following formula - can

anyone tell me what I've done wrong?

=SUMPRODUCT(--($A$35:$A$165=$B188),--(MONTH($CB$10:$CM$10)=MONTH(H$10))*($CB$35:$CM$165))

The formula looks up range ($A$35-$A$165)=$B188 and finds all occurrences of

"Metro A Group".

(The formula finds about 20 e.g. (1,1,1,1,1,0,0,1,...))

Then it looks up the month row ($CB$10:$CM$10) and finds the column that

matches the date in cell H10. The formula finds this in the first column for

Jan e.g. (1,0,0,0,0,0,0,0,0,0,0,...)

Then it's suppose to sum all relevant values in range $CB$35:$CM$165

This is where I think it's falling over?? and I get the circular reference??

$CB$35:$CM$165 rows have formulas totaling each row within the table.

I can't see any formulas within this range that cross calculate with any

cells in my formula???

Any help would be greatly appreciated.