Counting Instances of a Value?
 

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

Counting Instances of a Value?
 

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

Counting Instances of a Value?
 

=SumIf(B1:B5,"=Neil",A1:A5)