In my query I would like to have column J (Rentable Square Feet) insert a
subtotal when Owner Entity in Column C changes.

Column C Column J

Owner Entity Rentable Sq Ft
Company A 62,153
Company A 29,951
Company B 125,515
Company B 20,000

Company C 15,81
Company D 103,500
Company D 174,906

I would appreciate any assistance you can give me. Thx.