subtotal sumproduct

  1. Q

    Subtotal with Sumproduct and Criteria

    Looking to calculate a weighted average if there is a rate in column B, and then to be able to filter on other columns and have the subtotal update with the correct weighted average rate. Below is a copy of the formula I have thus far, where column B lists the rates and column A lists the...
  2. H

    Subtotal with if function help

    Hi, I have a data set like below and need to create a subtotal of the sections. I cant use the sum if function as the table will be filtered and need the section subtotals to be dynamic in line with the table filter. The filters are setup for BRAND,REGION,AREA and SITE. The idea is I have a...
  3. R

    Using Subtotal with countifs

    <tbody> Content Category Random Content 1 A Random Content 2 B Random Content 3 A Random Content 4 B Random Content 6 B </tbody> Dear, I know this type of question has been addressed before but I was having problem understanding the multiple formulae used and how it could be applied...
  4. G

    Subtotal STDev - With Criteria

    Hi, I have a flat table with the auto filter function. In column D2:D1000 I have 'Position' (e.g. Prop, Hooker, Scrum Half). In column G2:G1000 I have a score (e.g. 15.0, 15.7). In my subtotal table, I wish to have results that represent the scores of each position. The usual =SUBTOTAL...

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