Results 1 to 2 of 2

How can I calculate the subtotal for filtered cells that meet certain criteria?

Threaded View

  1. 12-28-2015, 09:00 PM #1
    jasond1992
    jasond1992 is offline
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    How can I calculate the subtotal for filtered cells that meet certain criteria?

    How can I calculate the subtotal for filtered cells that meet certain criteria?

    when i filter "A" the result is the total of all USD, what i want is the total only of USD, if the dont have the PHP the result in PHP is none.

    1.png

    2.png

    This is what i want the result....

    3.png
    Attached Files Attached Files
    Last edited by jasond1992; 12-28-2015 at 09:23 PM.
    Reply With QuoteRegister To Reply
« 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. Use Colorfunction and Subtotal togheter to count filtered coloured cells
    By Dome92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2015, 05:12 PM
  2. How to calculate unique count of values in a column that does not meet a criteria.
    By Vishnu Balan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2014, 04:05 PM
  3. How to subtotal SUMIF based on filtered cells
    By Nanny Pam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2013, 09:18 AM
  4. Counting filtered cells using SUBTOTAL
    By Russell Dawson in forum Tips and Tutorials
    Replies: 7
    Last Post: 10-07-2012, 12:11 PM
  5. Count filtered cells using SUBTOTAL
    By Russell Dawson in forum Excel Tips
    Replies: 2
    Last Post: 07-15-2012, 03:39 PM
  6. Subtotal Colored Cells from an Auto Filtered Column
    By goggle0 in forum Excel General
    Replies: 1
    Last Post: 06-24-2009, 08:18 AM
  7. How can I count cells that meet two criteria within a filtered co.
    By lizzzy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1