Formula Error
 

I am currently having a problem with the following:
I choose a destination cell d8 to perform the task of counting on sheet two.
When i go to sheet two and select the range I notice there are two bolded
boxes in random places. When I hit return the destination cell does not show
the the formula but has moved to A1. I have checked all my settings in the
calculation tab and it checked out ok. Anyone out there help me?