+ Reply to Thread
Results 1 to 2 of 2

Count Nº of clients per mth

  1. #1
    Registered User
    Join Date
    05-29-2009
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2007
    Posts
    78

    Count Nº of clients per mth

    Hi
    in the Sales B'down tab i need to count the Nº of clients per month on the business submitted tab i.e. the Nº of different ID numbers per month on the Bus. submitted tab. is there an easy way to do this by formula??
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Count Nº of clients per mth

    Hello,

    in the "Business Submitted" sheet, you are using merged cells across rows and columns. With these in place as column headers, any kind of analysis with formulas will be VERY difficult, if not impossible. Get rid of the merged cells, then it is possible to create a pivot table to summarise the data. But with the merged cells heading the table, this is not an option.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1