Results 1 to 15 of 15

Count formula needed...urgent

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2011
    Location
    West Bengal
    MS-Off Ver
    Excel 2007
    Posts
    76

    Count formula needed...urgent

    Dear Friends,

    A formula needed for..

    D14=COUNTA(D7:D12)

    where in range D7:D12, I want to count all cells having data, except cell containing "VACCANT".

    Please give me a formula.

    Thanks in advance

    Senjuti
    Last edited by senjuti.sarkar; 03-09-2012 at 02:01 AM.

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