+ Reply to Thread
Results 1 to 3 of 3

Count IF Across Multi Tabs to Exclude a value in final count

  1. 10-10-2022, 08:41 AM #1
    randomfluky
    randomfluky is offline
    Registered User
    Join Date
    07-16-2013
    Location
    aberdeen
    MS-Off Ver
    Excel 365
    Posts
    20

    Count IF Across Multi Tabs to Exclude a value in final count

    hello,

    I just have hit a brick wall (You know when your mind just wont funcation)

    I am trying to count the amount of people that are not "outdoor" workers across the several offices.

    I can count the amount of Outdoor workers from each office just want everyone else apart from Outdoor worked to be included.

    If anyone can please help me thank you

    P.s I know iBook 2.xlsxts a bit tame compared to other but just cant think
    Reply With QuoteRegister To Reply
  2. 10-10-2022, 09:20 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Count IF Across Multi Tabs to Exclude a value in final count

    Make sure you get all data on 1 worksheet (see my example office all)

    After that a pivot table to analyse the data.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 10-12-2022, 02:24 AM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Count IF Across Multi Tabs to Exclude a value in final count

    Thanks for the rep.

    Glad I could help.

    If you are satisfied with the solution, please mark the question 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] count all but exclude formula
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-01-2020, 12:39 AM
  2. [SOLVED] Count unique, but exclude some values
    By [email protected] in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2019, 03:04 AM
  3. Need Help to count the no exclude (DND) by Employee name
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2016, 02:41 AM
  4. COUNT but exclude if dat and name was included
    By TuboDieselOne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2016, 04:48 PM
  5. Count it multi criteria accross multi cells
    By jfoley5197 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2013, 03:42 PM
  6. Using SUMIF to count certain criteria but exclude others
    By Dan27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2011, 07:39 AM
  7. [SOLVED] exclude data from count
    By wdama13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2005, 12:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1