Results 1 to 8 of 8

COUNTIF without an array

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2018
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    COUNTIF without an array

    Hi there,

    I've been looking around forums with regards to COUNTIF functions without an array but I can't seem to find the perfect solution for my situation.

    Basically, I need to count only certain cells and if it satisfies the conditions. Eg. If COUNTIF could allow non-range cells, it'll look something like COUNTIF((A1,B2,C3),">3") and the result would be 2 if according to the sample table below

    A B C
    4 2 3
    3 5 4
    6 1 2

    Thus I would be selecting individual cells, counting them if it satisfies the condition.

    Hope someone could help!

    PS I've tried using a formula,with respect to the above table, COUNTIF(A1:A1:B2:B2:C3:C3,">3") but it doesnt seem to be correct.

    Thanks
    Last edited by Pinkkypie; 02-07-2018 at 08:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. array countif
    By Fabiany in forum Excel General
    Replies: 7
    Last Post: 10-02-2017, 12:00 PM
  2. [SOLVED] COUNTIF for Array
    By theTaoJones in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2017, 10:50 AM
  3. countif VBA Array's
    By samot79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2016, 08:44 PM
  4. countif from array
    By Bart00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2016, 03:49 PM
  5. [SOLVED] IF array with COUNTIF??????
    By alfgrey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2013, 07:10 AM
  6. [SOLVED] Countif in an array
    By Petijandro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 07:48 AM
  7. Array Countif
    By H43825 in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 12:04 PM

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