If a word is found in a cell range in E2:AT2 I want the total sum found in
that column below the word, or alternatively, the total found in that column
below the word, but in a certain row

This sounds like a simple CountIf formula. In the cell where you want the
results to posted type the following: =COUNTIF(Range,"Criteria"). Where range
would be E2:AT2 and Criteria would be the word you what counted in side
quotation marks

"AHOBBS" wrote:

If a word is found in a cell range in E2:AT2 I want the total sum found in
that column below the word, or alternatively, the total found in that column
below the word, but in a certain row

You don't say what the total is OF . Since your range is E2:AT2 I
presume you are totaling horizontally and when you come to text in a
cell in row 2 you want the sum of the cells in row 2 to the left of the
text, and that the text could appear more than once, and you want the
total from E-2 to wherever any, and all, text is. If I guessed right:

in cell F-3 type the formula =IF(ISTEXT(F2),SUM($E2:F2),"") , Copy the
formula to cells G-3 through AU-3.

or, in cell F-3 type the formula =IF(F2=" *whatever the expected word
is*",SUM($E2:F2),""). Copy the formula to cells G-3 through AU-3.

If I guessed wrong, what did you want? ed

Thanks very much - I have sent you a separate email explaining in more depth
and enclosing an example. If you can assist great, if not, then thanks for
trying.

" wrote:

You don't say what the total is OF . Since your range is E2:AT2 I
presume you are totaling horizontally and when you come to text in a
cell in row 2 you want the sum of the cells in row 2 to the left of the
text, and that the text could appear more than once, and you want the
total from E-2 to wherever any, and all, text is. If I guessed right:

in cell F-3 type the formula =IF(ISTEXT(F2),SUM($E2:F2),"") , Copy the
formula to cells G-3 through AU-3.

or, in cell F-3 type the formula =IF(F2=" *whatever the expected word
is*",SUM($E2:F2),""). Copy the formula to cells G-3 through AU-3.

If I guessed wrong, what did you want? ed