Hi All,
I am trying to get an accurrate count of the data in Column G from Source Data tab while excluding hidden rows. I want to have the result input into B14-B17 in the APAC tab.
The formula I am using currently is including the hidden rows in the total count.
=COUNTIF('Source Data'!$G$2:$G$10000,A14)
I have seen other solutions on this forum involving SUMPRODUCT, but am unable to apply these to my needs because I am not very excel savvy.
Thanks in advance for any help!
Bookmarks