+ Reply to Thread
Results 1 to 3 of 3

Multiple COUNTIF

  1. 02-02-2023, 02:43 AM #1
    grcshekar
    grcshekar is offline
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Multiple COUNTIF

    In the attached sample, I have COUNTIF in Column C and D. I want to add COUNTIF in Column D to Column C itself. So in C10 the output will be 22
    Attached Files Attached Files
    Last edited by grcshekar; 02-02-2023 at 03:52 AM.
    Reply With QuoteRegister To Reply
  2. 02-02-2023, 05:25 AM #2
    grcshekar
    grcshekar is offline
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Multiple COUNTIF

    How do i combine these two formulaes

    =COUNTIF(Attendance!D4:AH4,"P")
    =COUNTIF(Attendance!D4:AH4,"1/2P+1/2LOP")*0.5
    Reply With QuoteRegister To Reply
  3. 02-02-2023, 06:03 AM #3
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Multiple COUNTIF

    Why not keep it simple ???


    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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 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
  2. Multiple Values Total, Multiple Sheets (SUM/COUNTIF)
    By James95 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-31-2020, 04:48 PM
  3. Multiple Conditions with Multiple Outcomes (IF, AND, OR, COUNTIF, EDATE, MINIFS)
    By charliechaz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2020, 08:47 PM
  4. Countif, Multiple Criteria, Multiple Sheets, Excel 2003
    By shyammankoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 06:50 AM
  5. [SOLVED] trying to do a "countif" with multiple ranges and multiple criteria. Countif, Sumproduct?
    By completelyhis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 PM
  6. Trying to COUNTIF when multiple criteria are met on multiple column data set
    By TGCRequiem in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-15-2011, 12:58 AM
  7. Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1