Summing cell rows below a dept code based on dept name

[Apples52]

Wondering if this is possible.

Department name is in column D and earnings $ are in columns O-AH. I want the formula to be in the red text in column B. I have a 365 subscription.

What I'm trying to accomplish is summing the totals row O-AH for each department name starting on the row below "Totals for home department code xxx" Since the number of pay periods varies from month to month, I can't just apply a simple sum formula in the cells I have written "FORMULA" as that may not be where that "total" line lies in the next month if there are 5 pay periods.

For example, if the Dept Name "Sales" shows up in column D, sum the row starting below "Totals for Home Department Code 100" O-AH. This example should sum O6:AH6. Next month if there were 4 pay periods, the "Totals for Home Department Code 100" would move down a row to row 6, so the formula should grab O7-AH7.

 

[HighAndWilder]

Wondering if this is possible.

Department name is in column D and earnings $ are in columns O-AH. I want the formula to be in the red text in column B. I have a 365 subscription.

What I'm trying to accomplish is summing the totals row O-AH for each department name starting on the row below "Totals for home department code xxx" Since the number of pay periods varies from month to month, I can't just apply a simple sum formula in the cells I have written "FORMULA" as that may not be where that "total" line lies in the next month if there are 5 pay periods.

For example, if the Dept Name "Sales" shows up in column D, sum the row starting below "Totals for Home Department Code 100" O-AH. This example should sum O6:AH6. Next month if there were 4 pay periods, the "Totals for Home Department Code 100" would move down a row to row 6, so the formula should grab O7-AH7.

Investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked below.)

XL2BB - Excel Range to BBCode