Double Autofill formula + dynamic column sum

[juniorcomplete1]

Hi! I have seen a few autofill vba codes, all very helpful, but what if the autofill needs to skip one row in order to populate with the sum of the column just autofilled? based on a value in column A ? And then continue to autofill and then again sum back the second auto fill data?

 

[Peter_SSs]

If there is no blank line above Test2, then there is nothing for a formula in that row to sum.
So what would go in the cell on that row?

Example

juniorcomplete1.xlsm
	A	B	C	D	E	F
3	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT
4		TEXT	5632	2		598.4
5		TEXT	652	4		34.6375
6		TEXT	245	5		10.4125
7	Test1	TEXT	215	6		643.45
8	Test2	TEXT	23	4		???
Sheet3

Cell Formulas
Range	Formula
F4:F6	F4	=C4*0.2125/D4
F7	F7	=SUM($F$4:$F$6)

 

[juniorcomplete1]

Hi your absolutely right.
So the following would apply in the attached picture. So there will always be either a gap OR text between Test1 & Test2 sum rows.

 

[Peter_SSs]

Now you have rows with text in column A apparently some of which need a SUM formula and some don't.

None of Test1, TEXT or Test2 seem like real values so what is the logic of which ones get SUM formulas and which ones get the fill down formulas.