+ Reply to Thread
Results 1 to 3 of 3

Formatting a countifs statement

  1. #1
    Registered User
    Join Date
    06-11-2019
    Location
    United States
    MS-Off Ver
    Office 365?
    Posts
    6

    Formatting a countifs statement

    Working on a project that requires me to count fields with multiple criteria. Not sure how to format the formula. every time I have tried my formula will count based on if the fields have both instead of OR. I Will attach a link and picture of an example that would help me a lot. Also if you could demonstrate how to conditionally format the fields as well that would be fantastic.

    thanks everyone.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Formatting a countifs statement

    To start you off ...
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Formatting a countifs statement

    For the count based on your criteria:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For the conditional formatting, select A2:D21 then apply this CF formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] help with a countifs statement
    By djayk85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2018, 08:59 AM
  2. countifs and or statement
    By max8719 in forum Excel General
    Replies: 2
    Last Post: 11-05-2018, 09:53 AM
  3. [SOLVED] if statement with countifs statement with two variables
    By quentin5000 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-20-2018, 08:42 PM
  4. [SOLVED] Countifs statement help
    By Alaskan_grunt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-05-2016, 09:39 PM
  5. Or within Countifs statement
    By blens1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 10:22 PM
  6. [SOLVED] help nesting OR statement into COUNTIFS statement
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2014, 09:31 AM
  7. [SOLVED] =COUNTIFS statement
    By Glen- in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2014, 10:49 AM

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