if a word is in a cell I want the total in that column

[AHOBBS]

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

[SSG QuarterMaster]

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

[edcosoft@sbcglobal.net]

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

[AHOBBS]

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.

"edcosoft@sbcglobal.net" 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
>
>