I am trying to work with a list of data and working out the number of items within that data which tally to set criteria.

If I have a list of 10 items which value to 100,000 and I need to look at 80% of this (80,000) and then find the number of items which add up to this value in that range.

I am trying to use pivot tables as I have multiple result criteria.

Any help gratefully received.