+ Reply to Thread
Results 1 to 2 of 2

Sumproduct + countif

  1. #1
    Registered User
    Join Date
    10-02-2019
    Location
    Minneapolis, Minnesota (USA)
    MS-Off Ver
    Office14
    Posts
    1

    Sumproduct + countif

    Hello!

    I have created the table below using the following formula for column AB: =SUMPRODUCT((G2:G170<>"")*(COUNTIF(G2:G170,G2:G170)=1)/(COUNTIF(G2:G170,G2:G170)+(G2:G170="")))

    Capture.PNG

    I want to be able to change the labels in column AA to say "between 2 and 6 sessions" (so a range) , rather than simply "more than 1" (>1) as it is now.

    I tried converting the COUNTIF portion of the formula above to COUNTIFS but was not successful. Do I need to add (AND( somewhere?

    Thank you!!!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,597

    Re: Sumproduct + countif

    Hello Stephanie Knutson. Welcome to the forum.

    You usually get more and faster response if you attach an Excel workbook representative of what you are working with and what you hope to achieve.

    If you are not familiar with how to do this ...
    Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.
    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

    be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”
    The file name will appear at the bottom of your reply.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countif or sumproduct
    By pccamara in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-10-2015, 03:31 PM
  2. countif + sumproduct
    By dulitul in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2013, 03:27 PM
  3. [SOLVED] IF & COUNTIF or SUMPRODUCT
    By amphinomos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2013, 06:46 AM
  4. countif or sumproduct?
    By Darlo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2007, 09:06 AM
  5. [SOLVED] SumProduct or CountIf
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] SumProduct or CountIf
    By Kim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-08-2005, 08:05 PM
  7. countif, sumproduct
    By mg in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 07-01-2005, 06:05 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