Results 1 to 10 of 10

COUNTIFS with IFS and ANDS

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2021
    Location
    london uk
    MS-Off Ver
    Office 365
    Posts
    55

    COUNTIFS with IFS and ANDS

    Please can I have help with two different queries on the attached spreadsheet?

    1) I need a formula that counts if the value in column H is "NF01" AND the value in column F is either "Cans", "Bottles", OR "Britvic". I'm not sure how to factor in the either/or element for column F.

    2) Column G contains engineer numbers, and the numbers correspond to a region. Any engineer number between 1000-1999 is East, between 2000-2999 is West, and so on. Is there a way to count how many times column H is "NF01" for each region?

    Thanks so much
    Attached Files Attached Files
    Last edited by clari55a; 09-28-2021 at 11:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. More IFS & ANDS
    By Geekynerd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2018, 12:23 PM
  2. [SOLVED] IFS and ANDS
    By Geekynerd in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2018, 10:57 AM
  3. if and ands
    By sophia_1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2014, 03:01 PM
  4. COUNTIFS function with ANDs and ORs
    By Deutz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2014, 11:44 PM
  5. [SOLVED] Ifs ands countifs
    By HCBalelo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2012, 01:34 PM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. CountIFS / Ands or Buts :)
    By Rino468 in forum Excel General
    Replies: 3
    Last Post: 07-08-2011, 01:56 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