I have two worksheet, the first one with smartmarker that filled up a sheet with list of persons name per continent.
And in the second one I have summary page where I need to count the number of person per continent. The problem is that when I put the formula =COUNT(sheet1!A2:A2), the result after I do the export shows the same formula and not =COUNT(sheet1!A2:A30) , assuming that there is 30 row in the Sheet1.
The number 30 is just an example as this is a dynamic result.
Thanks for your help