| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
please help how to combine IF function with Countif function
Hi,
When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Combine two or more columns by using a function | Excel Discussion (Misc queries) | |||
| IF Function or Countif | Excel Worksheet Functions | |||
| COUNTIF FUNCTION | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
