+ Reply to Thread
Results 1 to 2 of 2

If Then Counting Formula

  1. #1
    Registered User
    Join Date
    11-18-2006
    Posts
    6

    If Then Counting Formula

    I have created a validation list. The list has only 2 items.
    (1) Closed (2) Open

    I want to count the number of opens and closed items. I want the count to be listed up at the top of the sheet in a different column than the validation list is located. If it is blank then it would not be included in the count.

    Thanks for your help.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    =countif(yourRange,"Closed")

    HTH
    Carim

+ 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