My subtotal and sum
sirs
Is there any formula in excel or VBA for this
if i write SUBTOTAL in A3 then a sum total of given range appears in B3
likewise if i write SUBTOTAL in B6 then a sum total of given range appears in C6
i have attached a sheet for details
plz help
|