Excel Help.
-
Currently bringing a sheet together including @Adam-Williams Results sheet. But I'm trying to include a P/L on it for just match odds markets. As i do like a set and forget over the weekend on certain odds. IE BACK 1.4 - 1.8 (Only Major Leagues). I currently have the spreadsheet set up with all P/L set up. But when i filter to prices, my overall P/L doesnt change.
Do i need to use macros?
Any help is appreciated.
Im willing to upload if someone wanted to have a fiddle around with it.
Thanks for the response's.
-
This has been solved thanks to @Andrew
-
Hi Ben
If memory serves me right if you are using autofilter any sum function still adds up all the data (even if hidden because of the filters). I think the function you need is SUBTOTAL but I couldn't tell you how to use it off the top of my head.
Hope that helps
Andrew