Auto sum formula next to particular text

Can it be done thr VBA or EXCEL

plz tell me
if i write SUBTOTAL in A3 the sum total of given range is auto done in B3

if i do that B5 then sum total should be in C5

a file is attached here

plz help me

AttachmentSize
Series.set_.xlsx7.43 KB