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

  • Thread starter Thread starter RBohannon
  • Start date Start date
R

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.
 
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.
 
Back
Top