Filtering in Corresponding Gross Value using VBA in Excel

[akpflow]

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 1	Filter 2	Date	Filter 3	`Gross Pay

<tbody>
</tbody>

 

[MUKESHY12390]

just upload couple of records form sample data and it would help to find out better solution.

 

[akpflow]

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...