Numbers 08/09 : Counting "not empty" cells?

Discussion in 'Mac Apps and Mac App Store' started by feri, Jan 18, 2009.

  1. feri macrumors newbie

    Joined:
    Apr 29, 2008
    Location:
    London, UK
    #1
    I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell. It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.
     
  2. reclusivemonkey macrumors 6502

    reclusivemonkey

    Joined:
    Jun 2, 2008
    Location:
    Sowerby Bridge, West Yorkshire, UK
  3. feri thread starter macrumors newbie

    Joined:
    Apr 29, 2008
    Location:
    London, UK
    #3
    Thanks a lot, yeeeeees. Exactly. THX

    Code:
    =COUNTA(value,value)
     

Share This Page