I have the following data in a worksheet
Client Currency Amount
x ‚¬ 95,000
x ‚¬ 80,000
y ‚¬ 65,000
z $ 70,000
z $ 20,000
az £ 15,000

the issue is if i use filter then the total (sum formula) will not apply on
filters it displays the amount of all entries, i can use SUMIF formula but
the problem is that there are more than one currency involved (my criteria
field), so is there any sort of combination of formula to filter the list and
get the desired result.