Filtering in Corresponding Gross Value using VBA in Excel

akpflow

New Member
Joined
Aug 2, 2016
Messages
9
Good day... I'm new in this forum...
I have a spreadsheet that uses filter to narrow down my search/selection but the gross value doesn't change.
I would love an excel shhet that has the corresponding gross value as the filter changes.
I can send you a dummy file for clarity.


Best,
Akpflow
Filter 1Filter 2
Date
Filter 3
`Gross Pay

<tbody>
</tbody>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

MUKESHY12390

Well-known Member
Joined
Sep 18, 2012
Messages
892
Office Version
  1. 2013
  2. 2011
  3. 2010
  4. 2007
Platform
  1. Windows
just upload couple of records form sample data and it would help to find out better solution.
 
Last edited:

akpflow

New Member
Joined
Aug 2, 2016
Messages
9
just upload couple of records form sample data and it would help to find out better solution.

Thanks Mukeshy, let use this :
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus
Vardy
Champions LEague
Home
40
40
Huth
Carling Cup
Away
70
110
Fuchs
Champions League
Away
110
220
Vardy
EPL
Home
50
270
Fuchs
EPL
Home
50
320
Huth
Champions League
Home
150
470

<tbody>
</tbody>
In this table above, There are three filters (player, game type, match).. Gross Bonus is the cumulative sum of the individual player's bonuses. How can I ensure that if one, two or all filters are active, the gross bonus will response promptly for example, when the filter 1 selects only Vardy, The gross bonus is 90:
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus
Vardy
Champions LEague
Home
40
40
Vardy
EPL
Home
50
90

<tbody>
</tbody>
Example 2: When the filter 2 selects EPL,
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus

<tbody>
</tbody>
Vardy
EPL
Home
50
50
Fuchs
EPL
Home
50
100

<tbody>
</tbody>
How can I achieve this?
Thanks in advance...
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,265
Messages
5,769,136
Members
425,519
Latest member
jriddle19

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top