filtered results

  1. M

    Sum values in one column based on unique, filtered values in another

    Please help me! I'm trying to sum filtered values from column J (course credits) based on unique values from column F (unique course ID). The desired result would return a count of 3 unique values (courses) for column F and a subtotal of 10 (credits) for column J. <tbody> A B C D E...
    • MRabelo
    • Thread
    • based on another cell filtered results sum across columns sum based on criteria unique counts
    • Replies: 8
    • Forum: Excel Questions
  2. A

    Model that can change when data is filtered

    I have built a model that is linked to a sheet of data. What I would like to do is let someone filter the data, say by state and then have the model change from showing all results to just those filtered results. The tricky part is that I need to use the countif and sumif functions to tell the...
    • ACF0303
    • Thread
    • filtered results modeling sumif and subtotal sumproduct subtotal
    • Replies: 7
    • Forum: Excel Questions
  3. D

    Count unique/distinct items in filtered column

    I'm going to do my best to explain: I have several colums with various pieces of equipment, serials and years. I may filter on one column, then I want to count the number of unique pieces of equipment left...Ultimately I may filter differently. Example: A B C YEAR...
  4. V

    Need to send mail to filtered people

    Hi All, I'm going to explain this as best as I can and hope I make sense. :) I have an excel workbook which is a result of a sports survey I conducted. It basically shows who likes which sport, what level they're at, preferred time of play, etc, and their email address. A colleague has...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top