Sumif & subtotal
Use Subtotal
=SUBTOTAL(9,C2:C7)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Blackwar" wrote in message
...
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.
|