Results 1 to 5 of 5

Perplexing Excel question

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2007
    Posts
    14

    Perplexing Excel question

    I have a question that involves counting. I have a list of job requirements in column B and a checking column in Column A (I type the letter "a" and a check mark appears). I use this to check off which requirements have been completed (there are 266). There are 2 types of job requirements: Core Tasks denoted by a "#" and regular tasks non denoted. I have set up Autofilters for both the "checks" column and the Job requirements column to easily sort through core tasks, regular tasks, both, and which ones have/have not been completed.

    My question is: I would like a formula that automatically counts how many requirements I have listed at any given time. I tried using various =COUNTIF formulas but I can't seem to t get it to work.

    Any suggestions? I've also tried to provide a snipit of my actual excel page for you to look at.
    Attached Images Attached Images

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