Excel Filter + New Calculations

[Greenlee]

Hello guys I need a bit of your help!

So here I will make an example of my problem

Column A Column B (wins) Column C (lose) Total trades : 4, Total Wins 3, Total Loss: 1
APPLE stock 1 0
APPLE stock 1 0
APPLE stock 0 1
GOOGLE stock 1 0

Now here When I filter Apple stocks I want to calculate only Total Trades of Apple it means it should be Total Trades: 3, Total wins 2, Total loss:1

How do I do that ? Much appreciate your answer in advance

 

[alansidman]

Excel Workbook
	A	B	C	D	E	F
1	ID	Wins	Lossses		Total trades	3
2	Apple stock	1	0		Wins	2
3	Apple stock	1	0		Losses	1
4	Apple stock	0	1
5	Google stock	1	0
Sheet1

 

[Greenlee]

First of all I would like to apologize for posting into the wrong section secondly I would like to thank you slansidman and at the same time I would like to ask you one more thing what about if there are 2 more conditions 1.st timeframe lets say: M30, M30,M30 and Strategies: bat, butterfly, so for my trades,wins and losses there would be those limits ( timeframe, strategy and of stock), that means I have three conditions I hope I was understandable enough Thanks in advance!

 

[alansidman]

suggest you review how to use countifs. Look at this link.

MS Excel: COUNTIFS Function (WS)

 

[mfexcel]

I think the function you are looking for is SUBTOTAL.
Try:
=SUBTOTAL(9,sumrange)
then apply the filter. Only visible range will be added.

Hello guys I need a bit of your help!

So here I will make an example of my problem

Column A Column B (wins) Column C (lose) Total trades : 4, Total Wins 3, Total Loss: 1
APPLE stock 1 0
APPLE stock 1 0
APPLE stock 0 1
GOOGLE stock 1 0

Now here When I filter Apple stocks I want to calculate only Total Trades of Apple it means it should be Total Trades: 3, Total wins 2, Total loss:1

How do I do that ? Much appreciate your answer in advance