# Excel Filter + New Calculations

#### Greenlee

##### New Member
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

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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Excel Workbook
ABCDEF
2Apple stock10Wins2
3Apple stock10Losses1
4Apple stock01
Sheet1

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!

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

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

Replies
1
Views
388
Replies
9
Views
427
Replies
7
Views
313
Replies
9
Views
1K
Replies
2
Views
219

1,219,770
Messages
6,150,167
Members
450,937
Latest member
kattyg261

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back