Counting Instances of a Value?

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

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
 
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
 
Back
Top