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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RBohannon - 02 Jun 2005 16:50 GMT

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.

Reply to this Message

RBohannon - 02 Jun 2005 16:56 GMT

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.

Reply to this Message

JE McGimpsey - 02 Jun 2005 16:57 GMT

Do you need a UDF?

Try

=COUNTIF(C6:C520,0)

> I'm familiar with VBA, but I have never written VBA in Excel.
>
[quoted text clipped - 4 lines]
> How would I write a function to count how many of a particular code
> there are in a given range, say C6:C520?

Reply to this Message