+ Reply to Thread
Results 1 to 3 of 3

Best method to calculate number of cells with a specific value (or no value)

  1. #1
    Registered User
    Join Date
    05-18-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Best method to calculate number of cells with a specific value (or no value)

    I'm in the process of creating a staff holiday planner. What I need is to create a summary worksheet, that will add up the total number of staff available over a month or weekly period.

    If I haven't explained that well, staff will select a cell if they won't be in on that day, that cell will then auto format to a specific colour and also have a text value indicating the type of holiday leave taken.

    If an employee is in work and therefore available, the cell will be completely blank (no formatting and no text value). Is it possible to use a vlookup (or similar) to search the worksheet for cells without any value inside, and bring a total number to a summary page to show the amount of staff in work over that week or month?

    This is my first attempt at creating anything from scratch in Excel so although I'm familiar with some terms, the actual functions are a bit alien to me. Unfortunately most google queries bring up guidance that flies over my head.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Best method to calculate number of cells with a specific value (or no value)

    Use COUNTIF
    e.g. COUNTIF(A1:Z1,"H")
    will count the number of "H"s (Holiday perhaps) in the range A1 to Z1
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    05-18-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Best method to calculate number of cells with a specific value (or no value)

    Thanks for the help

+ Reply to Thread

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