I need an excel formula to correctly count the number of acquired tracts (See attachment). The problem I am having is that it is over counting the total by 78. I have confirmed the numbers through counts and physical counts.
I think the problem is that I am trying to make sure I count acquired tracts and acquired permits seperately and there is a conflict causeing me to count an additional 78. 189 has been confirmed as the correct acquired permit count, so the additional 78 I think is in the acquired tracts. Its got to be double counting somewhere. I have been trying to figure this out, but its time for me to look a way for a minute.
In the attachment, i have tried to include as much information as possible on the INFO tab. Data is on the DATA tab.