+ Reply to Thread
Results 1 to 2 of 2

I want to get COUNTIF and then do SUM for my requirement - Reg.

  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    I want to get COUNTIF and then do SUM for my requirement - Reg.

    Dear forum,

    Need your help on this, I have to get the count with one criteria and then do the sum with specific text. Examples are given below

    Data set and my expected summary report (No. of times counselling given for specific issue by department and occupation wise only) as below in the scree shot.

    Screenshot 2016-09-21 13.50.54.png



    Need a formula for this.

    Thanks in advance
    Last edited by bala04msw; 09-21-2016 at 04:23 AM. Reason: formatting issue

  2. #2
    Registered User
    Join Date
    09-20-2016
    Location
    bhopal
    MS-Off Ver
    2003
    Posts
    17

    Re: I want to get COUNTIF and then do SUM for my requirement - Reg.

    Hi,

    If department and occupation continuously changing with new departments then you should use PIVOT (crosstab).

    PIVOT is better to get desired results in way u need.

+ 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. if minimum requirement isn't met
    By kieranoduill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2014, 07:06 PM
  2. Code Requirement
    By Alokshah7 in forum Excel General
    Replies: 1
    Last Post: 06-28-2013, 03:09 PM
  3. please help me to run this macro as per the requirement
    By vipulhumein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2013, 01:40 AM
  4. STAFFING REQUIREMENT with TAT
    By coolzero in forum Excel General
    Replies: 2
    Last Post: 12-13-2012, 04:01 PM
  5. Forcing Dim Requirement
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2006, 03:45 PM
  6. [SOLVED] formula requirement
    By pcor in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-07-2006, 06:50 PM
  7. Requirement in Bar chart
    By rajeshkumar in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-09-2005, 01:29 PM
  8. if until requirement met
    By stefan via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-28-2005, 03:05 PM

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