# subtotal if

1. ### Subtotal on Filtered Rows using Sumproduct - Wildcard substitute

I would love some help correcting this pickle! I need to show the total of 1 column, based on whether another column contains certain text. Looking through posts and blogs, I have gotten this far, but it will only total if BBA is the only Program in column P. It would solve my problem if I...
2. ### Sum Levels of Nested Subtotals

Hello, I am trying to write a macro that sums several layers of nested subtotals. The lowest level subtotals (subtotal 2) are already calculated and pulled from another tab. Subtotal 1 needs to ONLY be the sum of the individual Subtotal 2 lines. In my example below, the first subtotal 2 field...
3. ### Formula for subtotal with conditions, in Pivot with Calculation - Fields (Pivot - Analyze - Calculation - Fields - subtotal by condition IF or SUMIF)

This is Pivot table. Field1 is counted as Bottle price / Volume. But Subtotal for Field 1 is wrong. 21,2654321 is wrong answer, watching data, we understand that price of Bottle per Lt is 65. For some reason, Field 1 is taking all volume. Perfect Formula would look like this...

### 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.

### Which adblocker are you using?

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

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