Hi, I am trying to Count no.s equals to ZERO from column DB with this formula, but getting error. Can anyone help me.
There are 2 sheets in same workbook. I am trying to countif some data.
Formula used is :
This formula works well. But...
The case is, I don't want to use DB:DB in this formula, I want excel to refer this column automatically. That's why I tried using Index Match (referring current Month as "July" & "B")
Refer cell DB1 = 7B
Refer cell V1 = 7B (in 2nd sheet)
Don't know what is wrong in this formula. Please help.
@Sarav45 , in second INDEX the range shall be same size, like
@Sarav45 , you are welcome