+ Reply to Thread
Results 1 to 35 of 35

Multi-Column Counting - COUNTA or other Options

Hybrid View

argomike Multi-Column Counting -... 01-25-2012, 12:41 AM
MarvinP Re: Multi-Column Counting -... 01-25-2012, 12:49 AM
argomike Re: Multi-Column Counting -... 01-25-2012, 12:52 AM
e4excel Re: Multi-Column Counting -... 01-27-2012, 02:21 AM
e4excel Re: Multi-Column Counting -... 01-25-2012, 04:45 AM
e4excel Re: Multi-Column Counting -... 01-27-2012, 02:33 AM
e4excel Re: Multi-Column Counting -... 01-25-2012, 06:15 AM
e4excel Re: Multi-Column Counting -... 01-25-2012, 06:22 AM
Pete_UK Re: Multi-Column Counting -... 01-25-2012, 06:48 AM
argomike Re: Multi-Column Counting -... 01-26-2012, 03:17 PM
Pete_UK Re: Multi-Column Counting -... 01-26-2012, 09:45 PM
Pete_UK Re: Multi-Column Counting -... 01-26-2012, 09:47 PM
e4excel Re: Multi-Column Counting -... 01-25-2012, 07:56 AM
OnErrorGoto0 Re: Multi-Column Counting -... 01-25-2012, 08:07 AM
argomike Re: Multi-Column Counting -... 01-26-2012, 03:26 PM
argomike Re: Multi-Column Counting -... 01-26-2012, 03:27 PM
argomike Re: Multi-Column Counting -... 01-26-2012, 03:29 PM
MarvinP Re: Multi-Column Counting -... 01-26-2012, 11:16 PM
Haseeb Avarakkan Re: Multi-Column Counting -... 01-26-2012, 10:56 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-27-2012, 05:40 AM
argomike Re: Multi-Column Counting -... 01-27-2012, 02:29 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-27-2012, 03:58 PM
argomike Re: Multi-Column Counting -... 01-27-2012, 06:17 PM
Pete_UK Re: Multi-Column Counting -... 01-27-2012, 06:47 PM
argomike Re: Multi-Column Counting -... 01-27-2012, 07:10 PM
Pete_UK Re: Multi-Column Counting -... 01-28-2012, 07:59 AM
Haseeb Avarakkan Re: Multi-Column Counting -... 01-27-2012, 05:32 PM
Haseeb Avarakkan Re: Multi-Column Counting -... 01-27-2012, 07:35 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-27-2012, 07:49 PM
MarvinP Re: Multi-Column Counting -... 01-28-2012, 01:25 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-28-2012, 02:05 PM
MarvinP Re: Multi-Column Counting -... 01-28-2012, 02:36 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-28-2012, 02:39 PM
MarvinP Re: Multi-Column Counting -... 01-28-2012, 02:53 PM
OnErrorGoto0 Re: Multi-Column Counting -... 01-28-2012, 03:54 PM
  1. #1
    Registered User
    Join Date
    01-25-2012
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Multi-Column Counting - COUNTA or other Options

    Getting the same error I got with Pete, and there is data in that range.

    Quote Originally Posted by OnErrorGoto0 View Post
    =SUMPRODUCT(SIGN((A2:A9<>"")+(B2:B9<>"")+(C2:C9<>"")))
    You will need to adjust the ranges to match your data.

  2. #2
    Registered User
    Join Date
    01-25-2012
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Multi-Column Counting - COUNTA or other Options

    I'm thinking I may have to create a hidden column to run subtotals, similar to what Marvin proposed, but i'd prefer not to do that if anyone has ideas.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,232

    Re: Multi-Column Counting - COUNTA or other Options

    Helper columns aren't that hard to use. Many times they make problems a lot simpler by breaking them down into smaller pieces.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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