+ Reply to Thread
Results 1 to 5 of 5

COUNTIFS Non Blank cells

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    COUNTIFS Non Blank cells

    Hello all

    On sheet2, I have setup a list of stores.

    I want a formula in cell B2 to drag down which counts the number of non-blank cells from Sheet 1, column J, that match the retailer name in Sheet1 column A

    So I guess it's a COUNTIFS but I don't know how to count up the non-blank cells (combine the two...)

    i WAS TRYING SOMEthing like this: =COUNTIFS(Sheet1!J2:J51,<>"",Sheet2!A1,Sheet1!A2:A30))

    Please can someone help? thank you
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: COUNTIFS Non Blank cells

    how about
    =COUNTIFS(Sheet1!A:A,Sheet2!A1,Sheet1!J:J,"<>")
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: COUNTIFS Non Blank cells

    thank you I`ve got this to work!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: COUNTIFS Non Blank cells

    you are welcome

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: COUNTIFS Non Blank cells

    Maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Countifs with Blank cells
    By pickslides in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2022, 03:50 AM
  2. [SOLVED] COUNTIFS with blank cells
    By NiallC92 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-21-2021, 07:30 AM
  3. [SOLVED] COUNTIFS - Blank cells
    By blackburnsexcel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2021, 05:39 AM
  4. [SOLVED] CountIfs for not blank cells with condition
    By mutzie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2019, 08:17 PM
  5. CountIFS - ignore blank cells and cells with text in
    By whitebits in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2018, 12:43 AM
  6. [SOLVED] COUNTIFS for non-blank cells
    By DSwartz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2013, 03:39 PM
  7. Countifs should return blank results for blank row of cells
    By Groovicles in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-29-2013, 06: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