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

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

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

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

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