• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,
The important thing is to have the total detached of the table

I've remade the Filter to reach only to row 22

and then placed the subtotal at row 24

Regards
SubTotalFiltered-v1.xlsm
0
 
Frank FreeseAuthor Commented:
That's interesting. Even though the range stops at row 22 you need to have a blank row for your sub-total. Thanks
0
 
Frank FreeseAuthor Commented:
thanks - that was some good information
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now