Total Being hidden when I filter

[johns99]

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

 

[FDibbins]

Depending on what you are filtering on. make sure there is something in the TOTAL row that you can include in the filter? You cannot filter part of a row, it's all or nothing

 

[Latchmaker]

Two Solutions
1) Add Formula to Title Row
2) Add formula to bottom of file leaving a blank row between data and formula.

 

[johns99]

Thanks, I tried #2 , but this does not seem to be working. The data I am totaling is in cell N1668, which is summing data from column N3:N1686. The filter is applied to column E (country). When I filter on column E, cell N1668 is still being filtered as well, so I cannot see the total.