sumproduct subtotal

  1. 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
  2. K

    SUMPRODUCT use but with unknown number of rows

    Hi MrExcel. I am back after 10 years. Please have a look at the sample below. I need to put a value on every line having "file:" in the second column. The value requested is a sum of the numbers in the forth column following this line until the next "file:" line. I know it is not trivial, but...
  3. R

    Sumproduct w/Subtotal w/IF - need help with formula

    Hello, I want to sum a column on its filtered results, so I am assuming I need to use Subtotal. Then I need to include a conditional statement (if positive include in sum/if negative don't include in sum). I am then assuming I need to use sumproduct. I found some similar situations and formulas...

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