+ Reply to Thread
Results 1 to 3 of 3

URGENT help needed on Using advanced countif formulae for creating a statistics report

  1. 08-08-2013, 12:33 AM #1
    nikhilan
    nikhilan is offline
    Registered User
    Join Date
    08-08-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    URGENT help needed on Using advanced countif formulae for creating a statistics report

    Hi

    I need help with creating a statistics table that pulls information from mother table and provides the count of data available there. Sample table attached. Appreciate an early revert.


    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-08-2013, 12:43 AM #2
    elayaz
    elayaz is offline
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: URGENT help needed on Using advanced countif formulae for creating a statistics report

    Some thing like the attached...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-08-2013, 12:45 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: URGENT help needed on Using advanced countif formulae for creating a statistics report

    Hi and welcome to the forum

    If you want to count (sum) the occurrences, use this, copied down and across...
    =SUMIF($B$3:$N$3,B$11,$B4:$N4)

    If you want to count (count) the occurrences, ignoring if there is a 1 03 2 in a cell, use this, copied down and across...
    =COUNTIFS($B$3:$N$3,B$11,$B4:$N4,">0")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Creating formula using multiple Data Validation values
    By MichaelH2912 in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 08-13-2013, 11:00 AM
  2. Statistics function needed quickly
    By epossible in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2009, 02:01 PM
  3. Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...)
    By shadestreet in forum Excel General
    Replies: 2
    Last Post: 07-21-2006, 10:05 AM
  4. Help needed...test score statistics
    By Justin in forum Excel General
    Replies: 8
    Last Post: 07-07-2006, 08:40 PM
  5. Statistics - help needed
    By Eligator in forum Excel General
    Replies: 2
    Last Post: 09-04-2005, 09:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1