+ Reply to Thread
Results 1 to 4 of 4

Countifs over multiple worksheets issue

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    16

    Countifs over multiple worksheets issue

    Hi there,

    So one one spreadsheet I have this:


    Complaint ID # Team Coordinator Date Received Lessee First line of Address Borough Category Subcategory Allocated to Team
    101 jb 03-Jan-14 gftrs th dr h dr htrd Defect blah blah bg West
    102 jb 07-Jan-14 trs tr htd Defect blah blah bg West






    The rows go up to 200 as more data will be filled in over time.

    On another worksheet I have this:

    Date from 01/01/2014
    Date to 31/01/2014
    Team Compliments Complaints
    West
    North
    South
    S106
    P&Q

    In the complaints column I want to count how many rows are in the first worksheet if the date range in date received is between (inclusive) the date range above and if the team name is the same. Whenever I do this ()I am sure I'm filling all details in correctly) it comes up with zero.

    Please help! Have attached workbook as well.

    Thanks

    LucieNHHO Complaints Spreadsheet test 27.1 (version 2).xls

  2. #2
    Forum Contributor
    Join Date
    01-22-2014
    Location
    genoa, italy
    MS-Off Ver
    Excel 2007
    Posts
    134

    Re: Countifs over multiple worksheets issue

    http://wikisend.com/download/370712/NHHO Complaints Spreadsheet test 27.1 (version 2)-1.xlsx

    file of the link above

    it seems like this way it works

    AL

  3. #3
    Registered User
    Join Date
    01-28-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Countifs over multiple worksheets issue

    You have just turned my day into a good one. Thank you!!!

  4. #4
    Forum Contributor
    Join Date
    01-22-2014
    Location
    genoa, italy
    MS-Off Ver
    Excel 2007
    Posts
    134

    Re: Countifs over multiple worksheets issue

    :-) :-) :-)

+ 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] COUNTIFS Across multiple worksheets
    By PalaceOzzy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2014, 01:28 PM
  2. [SOLVED] CountIfs with multiple Criteria and Two Worksheets
    By richtree in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-12-2013, 07:17 PM
  3. Adding multiple COUNTIFS issue
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-17-2013, 06:40 AM
  4. worksheetfunction.countifs with loop from multiple worksheets
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2012, 04:55 PM
  5. Countifs alternative on 2003 with multiple cells and worksheets
    By Ex0dus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2009, 10:44 AM

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