countif with multiple criteria

[anand_g1987]

hi,
i need a formula in excel that should count as per the variable in column 2 with reference to column 1.
attached a excel file with desired result.

 

[NARAYANK991]

Hi ,

The logic is not clear.

Please revisit your data and see whether the values in the result column have been entered correctly.

Narayan