IF & dynamic Subtotal formula required

Copper Contributor

Hi Guys! Hoping someone can help me out here!
I'm trying to make a dynamic formula so that if "subtotal" is written in column A, various cells will calculate in other columns a subtotal but only of the cells in the column directly above it until there is a blank cell (this range will change each time). I have made a little example to demonstrate basically I need a subtotal in the yellow cells... Let me know if you have any ideas!   I'm thinking its a combination of IF & SUM 

1 Reply

@Geeeeee 

 

Why not just select all the yellow cells (press and hold the Ctrl key and select all the yellow cells one by one) and press Alt+=