Excel Help.

? Offline

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.

? Offline

This has been solved thanks to @Andrew

Martin

@ben-price I'm a very basic spreadsheet user so I just delete the prices lower or higher than target price (or price range I have noticed pattern of doing well) and then save it as a new sheet.

? Offline

@andrew Was correct Andrew, thanks just needed to know what the sum formula was inside SUBTOTAL. Thanks for the advice

? Offline

@andrew Thats doesnt seem to work, if using that it makes multiple different tabs on the left hand side of the screen.

Thanks for the help.

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