Hi All,

I have spreadsheet which has some accounts details .....

Column I - names column

Each account is been worked by different people and they will update
in the respective row of Column I.

Want I need is count of accounts worked by A, B........

I use =dcounta function to get the result..... I need a macro to do
that job.


Thanks

Set CountRange = Range("A1:E4")
Set CriteriaRange = Range("G1:G15")
total = WorksheetFunction.DCountA(CountRange, 3, CriteriaRange)

"muddan madhu" wrote:

Hi All,

I have spreadsheet which has some accounts details .....

Column I - names column

Each account is been worked by different people and they will update
in the respective row of Column I.

Want I need is count of accounts worked by A, B........

I use =dcounta function to get the result..... I need a macro to do
that job.


Thanks