And what do you get for a total, compared to what you expect? Also, your formula starts summing from row 12 - is there a reason for not starting from row 1?

And, when you're asked to post a sample, it would be helpful if you did that, instead of posting pictures of the worksheet. Your sample should include some representative data (delete anything sensitive)? You can post files via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]