Frank Freese
asked on
SubTotal on Filtered List
Folks,
Good morning to all hoping everyone enjoyed the weekend.
Here's my objective. I've attached a worksheet that has a filter on Relationship. I also understand that SubTotal is the correct function to use when filtering. I've already entered the SubTotal formula in D23. When I apply a Relationship filter the sub-total disappears. Is it possible to have a the sub-total be the last cell below the net amount regardless of the filering?
SubTotalFiltered.xlsm
Good morning to all hoping everyone enjoyed the weekend.
Here's my objective. I've attached a worksheet that has a filter on Relationship. I also understand that SubTotal is the correct function to use when filtering. I've already entered the SubTotal formula in D23. When I apply a Relationship filter the sub-total disappears. Is it possible to have a the sub-total be the last cell below the net amount regardless of the filering?
SubTotalFiltered.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks - that was some good information
ASKER