I have tagged excel sheet. There are 2 tabs. In 1st sheet"Khanewal" there is plan and actual locations visited. In sheet2 I have put countif formula to see how many persons were met.In sheet2, I wanted to drag the formula in such a way that it picks only plan and actual fro 1st sheet and not farmer visits and MD activities. Please help.
Bookmarks