PERFECT!!! Thank you so much!!!
"Chip Pearson" wrote:
Use the SUMIF function.
=SUMIF(B2:B10,"a",C2:C10)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"jacchops" wrote in message
...
Let's say I have 3 columns: "ID", "Phase" and "Number of
Employees". The ID
value is always unique and ranges from 1-20. The Phase options
are A or B. So
here is some sample data:
ID Phase Number of Employees
1 A 10
2 B 5
3 A 2
Can I set up a formula that adds up the number of employees
provided that
Phase=A? If I use COUNTIF, I can specify the Number of
Employees column as my
Range, but then I get lost when choosing my Criteria.