For Option 2 and 3 !
I use mostly office 2013, sharing would create problem also noticed when any company is completely removed summary gives error in Option 2.
Option 1:
But I prefer formulas instead of vb, as while sharing people are afraid of script codes and even sometimes file gets blocked.