Can I sum #s in a cell if other cells meet a certain criteria?
 

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.

Can I sum #s in a cell if other cells meet a certain criteria?
 

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.

Can I sum #s in a cell if other cells meet a certain criteria?
 

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.