[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[_3_]]

Hi

=COUNTIF(8:8,1)

--
Regards
Roger Govier

"sross002" wrote in message
...
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

[T. Valko]

Try this:

=COUNTIF(8:8,1)

--
Biff
Microsoft Excel MVP


"sross002" wrote in message
...
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