+ Reply to Thread
Results 1 to 3 of 3

countif for multiple sheets

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    153

    countif for multiple sheets

    Dear Experts
    please download my example sheet to see the problem.

    thanks
    Attached Files Attached Files
    Abdul Rouf Roofi

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,683

    Re: countif for multiple sheets


    F
    1
    FB
    2
    MR
    3
    ES


    In D10 Cell

    =SUMPRODUCT(1*COUNTIF(INDIRECT("'"&F1:F3&"'!N:N"),20))

    In D11 Cell

    =SUMPRODUCT(1*COUNTIF(INDIRECT("'"&F1:F3&"'!N:N"),50))


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    77

    Re: countif for multiple sheets

    Copy and Paste this formula in cell D10,
    =SUM(COUNTIF(FB!N1:N15,"=20"),COUNTIF(MR!N1:N15,"=20"),COUNTIF(ES!N1:N15,"=20"))

+ 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] COUNTIF across multiple sheets
    By lvl-48 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-29-2013, 03:57 PM
  2. Countif, Multiple Criteria, Multiple Sheets, Excel 2003
    By shyammankoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 06:50 AM
  3. CountIf across multiple sheets
    By Zhenya in forum Excel General
    Replies: 2
    Last Post: 09-16-2011, 12:56 PM
  4. Using countif to look at multiple sheets???
    By lukasj13 in forum Excel General
    Replies: 4
    Last Post: 10-08-2008, 01:57 PM
  5. COUNTIF across multiple sheets
    By Gizmo63 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2006, 06:45 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