can we use dcount function for below stated work i am also looking to solve simillar query in which i have one sheet of audit records and i want to see how many times audit conducted on each person thanks
On Wed, 03 Dec 2008 Dave Bonallack wrote : > >Hi, >SumProduct is a better function to use in this case. >If your names are in A2:A100 and activity is in B2:B100, then: >=SUMPRODUCT(--(A2:A100="person's name")*(B2:B100="Active")) >You can replace "person's name" with an address (eg C1) and type the name you >want to search into that cell. >=SUMPRODUCT(--(A2:A100=C1)*(B2:B100="Active")) >Similarly with "Active". >Note, the ranges in each set of brackets must be of equal size. >Regards - Dave.> Date: Tue, 2 Dec 2008 20:19:38 -0800> Subject: >$$Excel-Macros$$ Count function> From: [EMAIL PROTECTED]> To: >excel-macros@googlegroups.com> > > I have to use Count function, and I have >multiple criteria's for> example I have to count the number of times a >person's name is> apperaring in a sheet and again count if he is active member >or not> from the second column, please let me know how to use an array within> >this count function. Plz reply ASAP.> > >_________________________________________________________________ >Time for change? Find your ideal job with SEEK. >http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Atl%3Ask%3Anine%3A0%3Ahottag%3Achange&_t=757263783&_r=SEEK_tagline&_m=EXT >> REGARDS, Sanju --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
