I would probably start off by using an Advanced Filter and copying to another
location to produce a list of unique clients (see
http://www.allaboutoffice.co.uk/exfilter.htm - bottom of the page about
unique records) I would then use the COUNTIF function (
http://www.allaboutoffice.co.uk/excountif.htm ) to count the instances of
each client and then the SUMIF function (
http://www.allaboutoffice.co.uk/exsumif.htm ) to sum each client's project
values.

Andrea Jones

"Nigel" wrote:

Hi,
I need to count and separate the number of specific clients into lists with
their relative costs only. how can i acheive this? Example:
( say client list is B4:B1000. Project details C4:C1000 & Cost is D4:D1000)
Client1 project details £1000
client2 project details £3500
client1 project details £ 500
client1 project details £2000
client2 project details £1500
client3 project details £4000

my list would be:
3 Client1 £3500
2 Client2 £5000
1 Client3 £4000

any help greatly appreciated.
thanks, Nigel