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