jacob and Mike.

Countif worked perfectly. Knew there had to be a formula for that..

Thanks!!

"Mike H" wrote:

Hi,

Maybe this

=COUNTIF(A2:O2,"Text1")

Mike

"dgabriel" wrote:

I am working with a spreadsheet which has numbers and text in fields over a
large area:

for example, cells in a row would be: 435, 250, TEXT1, 400, 300, text2,
500....etc.
what I am looking to accomplish is to set a formula to say:

for each TEXT1 in a row, there should be a value of 1 added to a sum formula.

so if there are 6 TEXT1 cells in the row, the formula would result in a
value of 6.

Are there any formulas that can accomplish this in excel?

Any help is great.