Formulas
Hi - I have a work sheet with info as follows:
ColA ColB
A Smith £50.00
A Smith £40.00
D Jones £30.00
I want to count the number of people with packages between certain amounts
ie, £1 - £20, £21 - £50, £51 - £90, but if a person is on twice, i want them
to be counted as one, with the amounts added together. I want to show the
answers on another sheet and the results would be as follows:
ColA ColB
1-20 0
21-50 1
51-90 1
Is this possible?
Thanks in advance!
Becks
|