Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a statement (below) that works fine for finding all instances where a
person performed a task: =COUNTIF('Doc Log'!B2:B126,STATS!B3) (B2-B126 is where I'd find the person's name, and STATS!B3 is their name from a summary table) I want to add a statement so that I'd only count their name if, say C2:C126 has the value "Delivered" in it for that same line. For example if the first three lines we A1 B1 C1 1 Jan 06 | Smith|Delivered 1 Jan 06 | Simms|Reviewed 1 Jan 06 | Smith| Reviewed 1 Jan 06 | Smith| Delivered I need two statements for Smith COUNTIF "SMITH" and "Delivered" (SMITH and Delivered must be on same row!) COUNTIF "SMITH" and "Reviewed" In the example above, I also need to do COUNTIF "Simms" and "Reviewed" etc. Appreciate any help anyone might be able to provide! KSL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Logic question | Excel Discussion (Misc queries) | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif with AND logic | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |