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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding like job hours 5
Countifs and date comparison 3
Numbering Sequence 3
Countif Formula 1
Sum VLOOKUP 2
Excel Need Countifs Formula Help 0
Average if questions 2
adding numbers from column B, while condition on column A 4

Top