Results 1 to 25 of 25

Count if the sum of columns meet a condition

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    CA
    MS-Off Ver
    Excel 2007
    Posts
    23

    Count if the sum of columns meet a condition

    Hi all,

    I need your help. I want to set up a formula (countif???) to count the number of customers for each year in row 12 (file attached).

    Some customers don't buy anything for a year and then come back, which should be included in the count for that year. For example, customer C, F and H should be included in the count for the years 2012, 2007, and 2012 & 2013 respectively.

    I'm thinking to include customer C in the count of 2012 if sum(K4:L4) >0, but I don't know how to set up the countif formula to do that.

    I know I could create a dummy worksheet and run a formula for each cell to place 1 on each cell if the sum of the subsequent cells in the row >0, and then sum all the cells (i.e. 1s) in each year/each column to have the number of customers. If there are so many customers, my file might get big with the dummy worksheet.

    So it'd be great to set up a formula in row 12, instead of the dummy worksheet.

    Please help.

    Thank you so much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A formula to count subtotals if they meet a qualifying condition
    By JC_LA_1979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2015, 01:03 PM
  2. Count unique values within a range that meet a specific condition
    By CSS in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-24-2013, 02:00 PM
  3. [SOLVED] count number of cells which meet a particular condition for an individual
    By rohit43 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 11:20 AM
  4. Count text strings that meet a condition
    By dcgrove in forum Excel General
    Replies: 4
    Last Post: 09-14-2010, 03:38 PM
  5. count rows that meet two criteria in two different columns?
    By dsk3808 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-28-2006, 04:20 PM

Tags for this Thread

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