Dcounta
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 |
Dcounta
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 |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com