Hello,
I have the following formula which in a cell that I am using for a total. When I filter, the row containing this formula is being hidden. How do I exclude this row from being included in the filter?
=SUM(IF(ISNUMBER(MATCH($H$3:$H$1686,'Payline Analysis'!$D$10:$D$28,0)),'Comp Data Rpt 10-16'!$N$3:$N$1686))
Thank you in advance.
John
I have the following formula which in a cell that I am using for a total. When I filter, the row containing this formula is being hidden. How do I exclude this row from being included in the filter?
=SUM(IF(ISNUMBER(MATCH($H$3:$H$1686,'Payline Analysis'!$D$10:$D$28,0)),'Comp Data Rpt 10-16'!$N$3:$N$1686))
Thank you in advance.
John