Results 1 to 22 of 22

Need Formula that dosent count if the adjacent cell was already counted in

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    United States, NC
    MS-Off Ver
    2010
    Posts
    40

    Question Need Formula that dosent count if the adjacent cell was already counted in

    Here is what I have so far.

    (COUNTIF(Admission!H:H,"<=-24")+COUNTIF(Admission!I:I,"<=-24")+(COUNTIF(Admission!L:L,"<=-24")+(COUNTIF(Admission!O:O,"<=-24")+COUNTIF(Admission!H:H,"#")+COUNTIF(Admission!I:I,"#")+COUNTIF(Admission!L:L,"#Value!")+COUNTIF(Admission!H:H,">720")+COUNTIF(Admission!I:I,">720"))))

    Basically what I need it to do is not double count if any of the criteria in Column "H:H", Column "I:I", Column "L:L", and Column "O:O" were already counted.

    For example if Column "H:H, "<=-24 and Column "I:I", "<=-24" I only want it to be counted as once and not twice. Because COUNTIF(Admission!H:H,"<=-24")+COUNTIF(Admission!I:I,"<=-24") will result in a total of 2 and I need it to result in a total of 1.
    Last edited by Drscott21; 04-08-2016 at 08:59 AM. Reason: SOLVED

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2015, 09:02 AM
  2. Replies: 1
    Last Post: 12-15-2014, 09:49 AM
  3. Formula to count/total items in non-adjacent cells
    By mpatsis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2014, 01:42 AM
  4. Formula to count/total items in non-adjacent cells
    By mpatsis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2014, 01:06 AM
  5. [SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2013, 06:22 PM
  6. [SOLVED] A formula to count adjacent cell values?
    By Nate Westcott in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2012, 10:15 PM
  7. How do I set up the formula so that the A is counted?.-Count If
    By calli in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-06-2008, 02:05 PM

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