| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function to summarize based on 2 conditions?
Hi...i cant quite figure out how to do this or if there is a way to.
Ive got 3 columns.Employee Name in A,AccCode in B, Total of Hours in C. Each employee has multiple entries of hours per account code.Account codes are 100,101,102.How do list all the employee's who have put in time for Account 100 only. The result should look like Empname AccountCode Hours ABC 100 20 XYZ 100 56 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use IF function for two conditions | Excel Worksheet Functions | |||
| Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Threaded Mode
