Results 1 to 5 of 5

Help, Countif

Threaded View

  1. 02-02-2023, 01:09 PM #1
    Miche1e38
    Miche1e38 is offline
    Registered User
    Join Date
    02-02-2023
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    2

    Help, Countif

    I had this spreadsheet set up with just straight yes or no or na answers, and it worked fine, but then they filled out the sheet with y or n and some did yes or no and of course the formulas didn't work correctly. Is there a way for this formula to find the correct percentage possible if they do one way or the other or both ways?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNTIF and SUMPRODUCT. Multiply each row with COUNTIF if the condition is met.
    By Fishtail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2023, 04:29 PM
  2. [SOLVED] Countif on visible cells only & Countif from a cell with multiple entry
    By MushroomJ in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-26-2021, 05:37 AM
  3. [SOLVED] Help with countif formula for calendar (countif any date in table present)
    By KMJ256388 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2021, 12:11 PM
  4. IF statements with COUNTIF (including results of countif w/o having it in a separate cell
    By olga6542 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2020, 05:33 PM
  5. Adding a COUNTIF function to an existing IF AND COUNTIF Formula...
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2018, 10:09 AM
  6. Faster if/countif formula for flagging uniques - countif too slow
    By Speshul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 01:44 PM
  7. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1