Help Count a Specific Value in a Row

[sross002]

Hello,

Can someone recommend a function that could count how many times a
particular value appears in a row?

For example,
I want to count how many times the value 1 appears in row 8.
How do I write this function out so excel can compute this?

I have microsoft office 2003

 

[Roger Govier]

Hi

=COUNTIF(8:8,1)

 

[T. Valko]

Try this:

=COUNTIF(8:8,1)