+ Reply to Thread
Results 1 to 5 of 5

count and sum occurrence against a value

  1. 11-27-2015, 04:01 AM #1
    koshur
    koshur is offline
    Registered User
    Join Date
    11-27-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    3

    count and sum occurrence against a value

    I have two sheets, sheet 1 has names with total counts of statuses. I want to count the number of active and deactivated entries against each name.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-27-2015, 04:06 AM #2
    zbor
    zbor is online now
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,060

    Re: count and sum occurrence against a value

    This is a blank sheet.
    Please upload proper example.
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
  3. 11-27-2015, 05:13 AM #3
    koshur
    koshur is offline
    Registered User
    Join Date
    11-27-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    3

    Re: count and sum occurrence against a value

    my bad, I'm attaching the correct one. thanks for a quick response
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-27-2015, 06:00 AM #4
    zbor
    zbor is online now
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,060

    Re: count and sum occurrence against a value

    Here:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Watch out on $ distribution in formula.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-28-2015, 02:46 AM #5
    koshur
    koshur is offline
    Registered User
    Join Date
    11-27-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    3

    Re: count and sum occurrence against a value

    perfecto
    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. SUMIFS Question: Count Occurrence
    By swipethemagnets in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2015, 03:25 PM
  2. [SOLVED] Count until next occurrence formula needed
    By bwmuhich in forum Excel General
    Replies: 10
    Last Post: 06-23-2014, 03:11 PM
  3. [SOLVED] Count rows down to previous occurrence
    By imlearning in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-01-2013, 11:27 AM
  4. Count No. of occurrence of consecutive values
    By rvkadu1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2013, 06:42 AM
  5. [SOLVED] Count Intervals Before Next Occurrence
    By jasonsarea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2012, 05:10 AM
  6. Count the Occurrence Based on a Date
    By ChrisRocks in forum Excel General
    Replies: 2
    Last Post: 08-16-2011, 11:54 AM
  7. How to count the no. of occurrence of certain value if the range is filtered?
    By one8421 in forum Excel General
    Replies: 3
    Last Post: 11-11-2008, 12: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1