Hi all

I tried to write a sumproduct formula to find various text within a range
and then sum the totals for those rows found, but my attempts failed. If
anyone could suggest a formula - it would be very much appreciated:

Heres what I need the formula to do:
The user enters strings of words into any cells within range(B37:H165)

I need the formula to look in range(B37:H165) and find any rows containing
strings of text that include the words "production" or "installation" or "non
commission".

For those rows found, I need the formula to add all values in the same rows
€“ but over in column CB (the 1st months total column) i.e.

Within range(B37:H165) the formula finds that the word €œproduction€� appears
within text entered into cell C40
€œinstallation€� appears within text entered into cell D51
€œproduction€� appears within text entered into cell B70
€œnon commission€� appears within text entered into cell H150
The formula then goes to range(CB37:CB165) and sums the values in in the
rows found ie. =CB40+CB51+CB70+CB150

FYI - Columns €œI€� to €œCA€� contain general data.
FYI - Columns €œCB€� to €œCG€� contain monthly totals.

--
Thank in advance for your help
BeSmart