J
jacchops
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.
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.