Results 1 to 5 of 5

% of true and false excluding blank cells

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2022
    Location
    Virginia
    MS-Off Ver
    2022
    Posts
    4

    % of true and false excluding blank cells

    I have multiple columns with multiple "do the cells match" scenarios and I'm wanting to get a summary in % and total count for each of the rows.

    My logic was to write a bunch of true/false formulas and then another formula to count up the "true" and "false" to get a percentage. I also built in some exclusion criteria where the true/false formula will return a "" when the criteria is not met. The problem I'm having is that I'm not sure how to exclude the blanks from the total count to get a %

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. True or false formula giving wrong result for null and blank values
    By aniletc37 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2016, 04:20 AM
  2. [SOLVED] How to get 'TRUE', 'FALSE', and 'Leave BLANK', & also how to average some data
    By MaeglinBC3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-22-2015, 09:28 AM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. Multiple True or False + Sum of corresponding cells
    By CheezZZ in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-04-2013, 10:18 AM
  5. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  6. True/False Function, ignore blank
    By cicihk in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 03:20 AM
  7. True/False on whether a cell is blank or not
    By krayziez in forum Excel General
    Replies: 1
    Last Post: 06-06-2008, 02:36 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