Hi Members,
I am using COUNTIF function, the problem arises that if I insert a row after the last row than COUNTIF function do not include the last row in range.
In the attached workbook, I have two columns name and attendance the last row in sheet COUNT the number of "yes". If I add another row and put yes than the COUNTIF doesn't include that cell in range.
I know that there is a option in excel which enable to put any row added in between the range is automatically included in the function range but one has to enable this option. As I have a way much complex sheet than the attached example and it needs to be send to several peoples for their inputs therefore I cannot rely on this option since some people have that option enabled while other dont.
Is there any fullproof way to ensure that any additional rows would be automatically included in range of COUNTIF.
Thanks and Regards.
Bookmarks