Neil,
You can use the SUMIF function to do this. For example,
=SUMIF(B1:B10,"Neil",A1:A10)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Neil" wrote in message
...
Hi there, i have a column, and within each column, it will
either say:
Joe, Paul or Neil - and in the next column, it will have a
value, i want to
count the values for each name
e.g.
A B
3 Neil
2 Joe
3 Neil
4 Paul
Neil = 6
Joe = 2
Paul = 4
I dont know how to achieve this ??
any help greatly apreciated,
Thanks,
neil