User-Defined Function to Determine Content of Cells in a Range

[RBohannon]

I'm familiar with VBA, but I have never written VBA in Excel.

I have a worksheet that contains personal data on employees. Some
fields have codes that I need to find the sum of, for example for the
field ECode (column C) I need to count how many are "0", "1", "2", etc.

How would I write a function to count how many of a particular code
there are in a given range, say C6:C520?

Thanks.

[RBohannon]

I just found the COUNTIF function. It does exactly what I need. I was
sure there must be a built-in function, I just wasn't sure what to look
for.

[JE McGimpsey]

Do you need a UDF?

Try

=COUNTIF(C6:C520,0)



In article <[email protected]>,
"RBohannon" <[email protected]> wrote:

> I'm familiar with VBA, but I have never written VBA in Excel.
>
> I have a worksheet that contains personal data on employees. Some
> fields have codes that I need to find the sum of, for example for the
> field ECode (column C) I need to count how many are "0", "1", "2", etc.
>
> How would I write a function to count how many of a particular code
> there are in a given range, say C6:C520?