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

Attached Files

Series.set.xlsx (7.4 KB, 11 views)

Heavy cross poster
http://www.excelguru.ca/forums/showt...ed=1#post16829
http://www.mrexcel.com/forum/excel-q...total-sum.html
http://www.excelforum.com/excel-gene...ml#post3959186

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post