Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello fellow Excellians,
On my last question I got a perfect answer. I wanted to know how many times a particular value could be found in a certain column in a certain tab. Now I want to know how I can use the same by selecting two values. I have a sheet with the following values. Date In (Column A) Number (Column B) Solved by (Column C) Flow (Column D) Cause (Column E) etc, etc Now I want to know how many times the person (in Column C) has solved a particalur issue concerning a Flow (Column D). With selecting only one value (for the situation how many times does a certain person solve an issue you will use the following statement =COUNTIF($F$2:$F$12336;c1) ). But how do you include an and in this statement as you make a selection on two different values. I will be very gratefull for your answer. -- ** Fool on the hill ** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
Using CountIf with criteria on another sheet | Excel Worksheet Functions | |||
Countif in two columns and in different cells | Excel Discussion (Misc queries) | |||
how do I create more than 266 columns in an excel sheet? | Excel Discussion (Misc queries) | |||
Columns in excel sheet | Setting up and Configuration of Excel |