+ Reply to Thread
Results 1 to 21 of 21

SUMPRODUCT with COUNTIF to find unique entries

Hybrid View

  1. 11-07-2012, 11:07 PM #1
    crzu
    crzu is offline
    Forum Contributor
    Join Date
    09-11-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    103

    Re: SUMPRODUCT with COUNTIF to find unique entries

    @ FDibbins

    Sorry I left out my objective. It is to count the number of customers visiting in the month.

    As the example data show that customer "CN00062" visited twice in the month of May. So the formula is suppose to allow the calculation of unique entries.

    Probably you could see the above attached file for more details?
    Click * to reward me...
    Thank you...
    Reply With QuoteRegister To Reply
  2. 11-08-2012, 09:10 AM #2
    crzu
    crzu is offline
    Forum Contributor
    Join Date
    09-11-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    103

    Re: SUMPRODUCT with COUNTIF to find unique entries

    bump.. anyone?
    Reply With QuoteRegister To Reply
  3. 11-09-2012, 02:54 AM #3
    crzu
    crzu is offline
    Forum Contributor
    Join Date
    09-11-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    103

    Re: SUMPRODUCT with COUNTIF to find unique entries

    Attached the file again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1