Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Instances of a Value?
=SumIf(B1:B5,"=Neil",A1:A5)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Consecutive Instances | Excel Worksheet Functions | |||
Counting instances in string | Excel Discussion (Misc queries) | |||
Counting instances of text??? | Excel Worksheet Functions | |||
Counting Multiple Instances | Excel Worksheet Functions | |||
Counting instances in a cell | Excel Discussion (Misc queries) |