IF & dynamic Subtotal formula required

%3CLINGO-SUB%20id%3D%22lingo-sub-1488230%22%20slang%3D%22en-US%22%3EIF%20%26amp%3B%20dynamic%20Subtotal%26nbsp%3Bformula%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20Guys!%20Hoping%20someone%20can%20help%20me%20out%20here!%3CBR%20%2F%3EI'm%20trying%20to%20make%20a%20dynamic%20formula%20so%20that%20if%20%22subtotal%22%20is%20written%20in%20column%20A%2C%20various%20cells%20will%20calculate%20in%20other%20columns%20a%20subtotal%20but%20only%20of%20the%20cells%20in%20the%20column%20directly%20above%20it%20until%20there%20is%20a%20blank%20cell%20(this%20range%20will%20change%20each%20time).%20I%20have%20made%20a%20little%20example%20to%20demonstrate%20basically%20I%20need%20a%20subtotal%20in%20the%20yellow%20cells...%20Let%20me%20know%20if%20you%20have%20any%20ideas!%26nbsp%3B%20%26nbsp%3BI'm%20thinking%26nbsp%3Bits%20a%20combination%20of%20IF%20%26amp%3B%20SUM%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1488230%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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+=