Results 1 to 9 of 9

Countif function not working at all on Mac

Threaded View

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Germany
    MS-Off Ver
    Excel: mac 2011 (14.2.5)
    Posts
    13

    Countif function not working at all on Mac

    My countif function doesn't work at all. I have version 14.2.5 for mac (OS X) and have updated it completely but still it doesn't work. If I try to write the same formula in windows excel, then it works just fine, so it isn't the formula that has an error.

    I was using the following simple example:
    Data
    apples
    oranges
    peaches
    apples

    =COUNTIF(A2:A5,"apples")

    But no matter what, I always get: "The formula you typed contains an error"
    on the formula.

    Do anyone know what to do?
    Last edited by galaxytraveler42; 11-23-2012 at 12:17 PM.

Thread Information

Users Browsing this Thread

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

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