Choose merged cell and sum data

[PWK]

I have a worksheet with the following data. I want to choose 010 then
sum 'total sent' with a formula. The problem I'm having is the 6
cells containing 010 that I'm referencing are merged. I maybe
eventually accessing many simular worksheets possibling using VBA



Site Number Metrics Total Sent Total Failed
010 13 1 0
112 2 0
197 3 0
199 2 0
214 1 0
218 1 0
011 13 1 0
199 1 0
012 315 1 0
015 13 1 0
021 199 1 0
Total 15 0

 

[PWK]

I can forward worksheet, it didn't cut and paste well.