+ Reply to Thread
Results 1 to 2 of 2

How to use multiple entries of countifs and subtotal in same cells with diff criteri

  1. #1
    Registered User
    Join Date
    04-09-2010
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    How to use multiple entries of countifs and subtotal in same cells with diff criteri

    In a given work book I have total 6 worksheet but I am facing problem in sheet named as “Master Report and Chart” in This sheet I want to build such reports and charts beside it, with the help of countifs, sumifs and subtotal (Reference given in that sheet) So, it can work no matter which dropdowns I select.

    Kindly let me know in case my problem is not precise.

  2. #2
    Registered User
    Join Date
    08-15-2008
    Location
    Mass
    MS-Off Ver
    2016, 64- Bit
    Posts
    28

    Re: How to use multiple entries of countifs and subtotal in same cells with diff crit

    I think what you might want to try and do is to perform all your calculations in seperate cells, then perform a sum of all those fields.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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