+ Reply to Thread
Results 1 to 9 of 9

=count.if (range of cells, ">=1") error

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Espaņistan
    MS-Off Ver
    2019
    Posts
    9

    Question =count.if (range of cells, ">=1") error

    Why! why im getting error?

    The thing is i want to create a range of cells to be counted IF the values on the cell is greater or equal to 1

    =CONTAR.SI(O4:O8;O12:O16;O20:O24;O28:O32;O36:O40;O44:O48,">=1")

    Something is wrong... but i don know what exactly
    Last edited by dapeben480; 03-16-2021 at 03:50 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: =count.if (range of cells, ">=1") error

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    02-24-2021
    Location
    Espaņistan
    MS-Off Ver
    2019
    Posts
    9

    Re: =count.if (range of cells, ">=1") error

    Here an example
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: =count.if (range of cells, ">=1") error

    see file. you CAN do this but it is a bit fiddly...


    =SUM(COUNTIF(INDIRECT({"O4:O8","O12:O16","O20:O24"}),">1"))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    02-24-2021
    Location
    Espaņistan
    MS-Off Ver
    2019
    Posts
    9

    Re: =count.if (range of cells, ">=1") error

    The formula works on Microsoft excel, but seems not works on google sheet where i have the excel

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: =count.if (range of cells, ">=1") error

    You never said it was for Google shhets. I am moving the thread to the corrct sub-forum.

  7. #7
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: =count.if (range of cells, ">=1") error

    This works for me;

    Please Login or Register  to view this content.
    Last edited by Haluk; 03-12-2021 at 12:05 PM.

  8. #8
    Registered User
    Join Date
    02-24-2021
    Location
    Espaņistan
    MS-Off Ver
    2019
    Posts
    9

    Re: =count.if (range of cells, ">=1") error

    Quote Originally Posted by Haluk View Post
    This works for me;

    Please Login or Register  to view this content.
    It worked! thanks!

  9. #9
    Registered User
    Join Date
    03-28-2021
    Location
    Minneapolis, MN
    MS-Off Ver
    2019
    Posts
    7

    Re: =count.if (range of cells, ">=1") error

    Glad you got this solved

+ 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] If Not ActiveSheet.Range("A1").Value Like "apple" Then MsgBox "Error"
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-18-2014, 02:16 PM
  2. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Error rsh = Sheets(st).Range("A" & Rows.Count).End(xlUp).Row + 1
    By Jocatlett in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-12-2013, 10:52 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"
    By lukasj13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 08:48 PM
  7. Problem using "Cells" in "Range" "400" error
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2009, 05:46 PM
  8. Why does =countif(range,"<>""") count empty cells?
    By Ingeniero1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2008, 01:40 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