Hi All
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.
--
Thank for your help
BeSmart