Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I have the following formula and many others like it to get totals.
However, I will be using a filter so I will need to have some sort of "Subtotal" in the equation. The formulas do work as do the filter buttons you see above the totals page. I'm hoping to tweak each formula to show only the filtered results in the table above the database. Also I will need the totals to revert back to the grand totals once the filter is turned off. I wish I could use the pivot/slicer process but my supervisor wants be to stay away from it. I will create one once people get use to this process. Thank you.
Excel Formula:
=SUMPRODUCT(D16:D100001,--(C16:C100001="Originating"))/2000