Results 1 to 6 of 6

Countifs: Multiple Criteria in Same Range with Other Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2019
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    3

    Countifs: Multiple Criteria in Same Range with Other Criteria

    Is there a way to count multiple criteria in the same range in a countifs function even though there are other criteria that needs to be considered.

    Below is what I came up with but I need to add Math1, Science1, History1, and English2 [edited as first sample was too easy to solve/sample excel file will have other subjects in it. Sorry ] in the 5th criteria. (Note: Not the actual data as it is confidential but is very similar.)


    =COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English1",Raw!E:E,"Teacher A")


    Basically, I need it to count all English1, English2, English3, English4, and English5 in the same column but still consider all the other variables in the existing formula.

    I was thinking nested formula but I can't figure out what function I should use and how to execute it. I also tried this

    =COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English1",Raw!E:E,"Teacher A")+COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English2",Raw!E:E,"Teacher A")+COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English3",Raw!E:E,"Teacher A")+COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English4",Raw!E:E,"Teacher A")+COUNTIFS(Raw!A:A,"Jul",Raw!F:F,"Yes",Raw!B:B,"No",Raw!C:C,"Teacher",Raw!D:D,"English5",Raw!E:E,"Teacher A")

    but this is too long and would take a lot of time since my data contains numerous teachers, subjects and numerous raw data file entry. Can someone help me with this?
    Attached Files Attached Files
    Last edited by ejpal; 08-14-2019 at 06:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNTIFS with Multiple Text Criteria in Same Criteria Range
    By xl2016 in forum Excel General
    Replies: 5
    Last Post: 06-18-2017, 05:00 AM
  2. Countifs with multiple criteria in single criteria range
    By SUHAS KARHADKAR in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-01-2016, 10:55 AM
  3. Countifs with multiple criteria in single criteria range
    By MCP313 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2016, 03:51 AM
  4. Countifs with multiple criteria and data range
    By Pritirus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2016, 01:18 PM
  5. [SOLVED] COUNTIFS with multiple criteria in the same criteria range
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2015, 01:04 PM
  6. COUNTIFS with Multiple Criteria in One Range
    By mphillips in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2013, 02:43 PM
  7. Countifs with multiple criteria in a single range
    By Wolfpackfan320 in forum Excel General
    Replies: 1
    Last Post: 02-27-2012, 04:54 PM

Tags for this Thread

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