software

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,quot;Criteriaquot;). Where range
would be E2:AT2 and Criteria would be the word you what counted in side
quotation marks

quot;AHOBBSquot; wrote:

gt; If a word is found in a cell range in E2:AT2 I want the total sum found in
gt; that column below the word, or alternatively, the total found in that column
gt; 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),quot;quot;) , Copy the
formula to cells G-3 through AU-3.

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

If I guessed wrong, what did you want? edThanks 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.

quot; wrote:

gt; You don't say what the total is OF . Since your range is E2:AT2 I
gt; presume you are totaling horizontally and when you come to text in a
gt; cell in row 2 you want the sum of the cells in row 2 to the left of the
gt; text, and that the text could appear more than once, and you want the
gt; total from E-2 to wherever any, and all, text is. If I guessed right:
gt;
gt; in cell F-3 type the formula =IF(ISTEXT(F2),SUM($E2:F2),quot;quot;) , Copy the
gt; formula to cells G-3 through AU-3.
gt;
gt; or, in cell F-3 type the formula =IF(F2=quot; *whatever the expected word
gt; is*quot;,SUM($E2:F2),quot;quot;). Copy the formula to cells G-3 through AU-3.
gt;
gt; If I guessed wrong, what did you want? ed
gt;
gt;