Hello,
I've attached a spreadsheet I use to track trades in the stock market. What I want to do is on the FX Equity Chart tab, I want that chart to update when I filter trades from the FX trade log tab. I have trade different sumproduct functions, but have been unsuccessful. Any help is appreciated.
Mark
I traced precedents to find a formula to apply a SUBTOTAL/OFFSET component to. I changed the formula in 'FX Trade Log' K14 to this and filled down. Then applied filter to the dates in 'FX Trade Log'. The chart updates. Check that it updates as expected. You may want to apply the SUBTOTAL/OFFSET to another formula instead.
If you are not familiar with SUBTOTAL it has several functions. COUNTA (3 or 103) is one of them. It will ignore invisible / hidden values. That effect carries over to column T 'FX Equity Chart'.
Formula:
Please Login or Register to view this content.
Last edited by FlameRetired; 09-11-2018 at 01:30 PM.
Dave
That works great! Thank you Dave!
You are welcome. Thank you for the feedback and marking this thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks