| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
couontif function
Hi,
I need a countif function for the below data. In the column C i need a formula where it will calculate the no of count of "ABC" from coulmn "A" and with condition "Manual" in column "B". Name Process Need formula ABC Manual ABC Automatic CDF Automatic ABC Manual ABC Manual DEF Manual CDE Automatic DEF Manual |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
couontif function
Radhakant....
if i were you, i would use pivot table... thanks "Radhakant Panigrahi" wrote: Hi, I need a countif function for the below data. In the column C i need a formula where it will calculate the no of count of "ABC" from coulmn "A" and with condition "Manual" in column "B". Name Process Need formula ABC Manual ABC Automatic CDF Automatic ABC Manual ABC Manual DEF Manual CDE Automatic DEF Manual |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
couontif function
Hi Reza,
I have 25-30 different sheets datewise and have to make 25-30 pivot tables...so i need countif fnction so that i can make the count in a single sheet... "reza" wrote: Radhakant.... if i were you, i would use pivot table... thanks "Radhakant Panigrahi" wrote: Hi, I need a countif function for the below data. In the column C i need a formula where it will calculate the no of count of "ABC" from coulmn "A" and with condition "Manual" in column "B". Name Process Need formula ABC Manual ABC Automatic CDF Automatic ABC Manual ABC Manual DEF Manual CDE Automatic DEF Manual |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
couontif function
Radhakant Panigrahi...
sorry..you can use countifs formula let say column Names is Col A and Column Process is Col B =COUNTIFS(A:A,"ABC",B:B,"MANUAL") hope this help you "Radhakant Panigrahi" wrote: Hi Reza, I have 25-30 different sheets datewise and have to make 25-30 pivot tables...so i need countif fnction so that i can make the count in a single sheet... "reza" wrote: Radhakant.... if i were you, i would use pivot table... thanks "Radhakant Panigrahi" wrote: Hi, I need a countif function for the below data. In the column C i need a formula where it will calculate the no of count of "ABC" from coulmn "A" and with condition "Manual" in column "B". Name Process Need formula ABC Manual ABC Automatic CDF Automatic ABC Manual ABC Manual DEF Manual CDE Automatic DEF Manual |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
couontif function
Try the below
=SUMPRODUCT((A1:A10="ABC")*(B1:B10="Manual")) If you are using XL2007 check out help on COUNTIFS() -- Jacob (MVP - Excel) "Radhakant Panigrahi" wrote: Hi, I need a countif function for the below data. In the column C i need a formula where it will calculate the no of count of "ABC" from coulmn "A" and with condition "Manual" in column "B". Name Process Need formula ABC Manual ABC Automatic CDF Automatic ABC Manual ABC Manual DEF Manual CDE Automatic DEF Manual |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
