Results 1 to 7 of 7

COUNT involving several columns

Threaded View

nsd3 COUNT involving several... 09-07-2009, 02:39 AM
DonkeyOte Re: COUNT involving several... 09-07-2009, 02:59 AM
DonkeyOte Re: COUNT involving several... 09-07-2009, 03:23 AM
martindwilson Re: COUNT involving several... 09-07-2009, 03:41 PM
daddylonglegs Re: COUNT involving several... 09-07-2009, 03:48 PM
martindwilson Re: COUNT involving several... 09-07-2009, 03:52 PM
nsd3 Re: COUNT involving several... 09-07-2009, 10:03 PM
  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Australia
    Posts
    40

    COUNT involving several columns

    Hi, I need to find a formula on cell A2 on the attached file. The formula should show me the count of Customers who buy SKU 1 only.

    I tried to use filters across SKU (2-16) where there is "0" and then count all customers who have values >0 on Column B. But this takes a long time and I have to do similar tables quite a few times. I was just hoping if anyone can come up with a more efficient solution to it.

    Regards.
    Attached Files Attached Files
    Last edited by nsd3; 09-07-2009 at 10:04 PM.

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