| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete data in cells that don't meet criteria | New Users to Excel | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Counting Consecutive Cells that meet Criteria | Excel Discussion (Misc queries) | |||
| Counting cells that meet 2 differnet criteria | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
