Results 1 to 4 of 4

Count Formula not working Excel Mac 2011

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Chicago
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Count Formula not working Excel Mac 2011

    I am trying to count the number of cells with the value of Surcharge Amt: $0.00 using the formula =COUNTIF(A5:A1012415,"Surcharge Amt:$0.00") I placed formula on cell A2 of attached workbook.

    It returns 0 as the answer but I know there are thousands...

    Please help me with this formula...

    I have a meeting tomorrow morning regarding the attached and I just can't get it!

    On another note, I am looking for someone to complete some excel work for me, mostly writing macros.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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