Results 1 to 8 of 8

COUNTIF Adding New Reference cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2018
    Location
    Chicago, USA
    MS-Off Ver
    2016
    Posts
    16

    COUNTIF Adding New Reference cells

    So what I'm trying to do is have an attendance sheet where attendee id numbers are put in one column and it removes their name from an absent list. This way, when all attendees have "shown up", I can quickly see who is missing.

    The problem I am having is updating the master attendee list. If I need to add someone in the middle of the list (for alphabetical order sake) the COUNTIF function I am using does not add.

    I am using the insert cell command to add more attendees to the list (in columns H and I), but column E will not update my "Absent" list.

    I have attached pictures and a sample workbook. Is there any way to make these lists dynamic so I can easily update my Attendee and ID list on the fly?

    Any advice would be really appreciated!!

    Working Page.PNG

    Not Working Page.PNG
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy formula across cells not changing cell reference COUNTIF
    By rj16184 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2018, 05:55 AM
  2. [SOLVED] Countif code that counts cells based on text string specified in a reference cell
    By john quinn in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-08-2015, 06:30 PM
  3. How to COUNTIF adding conditions on cells relative to each other?
    By Fallschirmjaeger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-15-2014, 04:54 AM
  4. [SOLVED] Adding Conditions to change the range of cells used in a countif formula
    By tcusack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2013, 02:12 PM
  5. Adding numbers from cells that match a criterion from COUNTIF ?
    By annekrijn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2013, 11:25 AM
  6. Does COUNTIF work if adding non-sequential cells i.e. not a range
    By BelindaJS in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-27-2012, 11:07 AM
  7. Reference Cells with Sumif or Countif
    By GK in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-03-2005, 02:06 PM

Tags for this Thread

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