Results 1 to 19 of 19

Need help with a Multiple COUNTIF and IF statement

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    England
    MS-Off Ver
    Office 2019
    Posts
    33

    Need help with a Multiple COUNTIF and IF statement

    Hi need some excel help, does anyone know of a formula in Excel to count cells in a range if they do not equal a ?U? and then double the count in a cell one of the columns cells in that range.

    For example cells row one column A:C have 3 grades All are 9-1 grades so would need that to equal 4 in Cell D
    However if row 2 contains a U in A:B but a 9-1 in column C it would enter 2 as the count in Column D.
    I?ve got the count only formula if not a u but can?t quite work out how to add a formula to double the count in in column C if it?s not a U
    =if(countif(RANGE,?<>U?)=0,0, (countif(RANGE,?<>U?)+1))

    The above still counts a U so i get 3 in cell D4 instead of 2

    Hope that makes sense? I've attached an example to help understand
    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. CountIF Statement with multiple criteria using the Today() Function
    By tkelbel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-07-2019, 09:39 AM
  2. [SOLVED] COUNTIF with an OR Statement - Checking multiple columns for a value
    By mason0567 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2019, 05:48 PM
  3. Adding CountIf Statement within If/ElseIf Statement
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2014, 05:09 AM
  4. [SOLVED] Multiple If's in CountIf Statement
    By NeoFlex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2013, 02:56 PM
  5. [SOLVED] Multiple CountIf Statement using TEXT and MONTH
    By GonzoSS in forum Excel General
    Replies: 2
    Last Post: 09-20-2012, 03:11 AM
  6. Multiple Countif Statement for Excel 2003
    By Mile029 in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 02:58 PM
  7. [SOLVED] COUNTIF Statement with Multiple Conditions in Different Ranges
    By KJA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2005, 01: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1