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