Hi everyone I have a column with ID'S this column is dinamyc so it will grow up, next to it I have a count formula for the number of text appearing this one:

=COUNTIF(F3:F12,"?*") COUNT(F3:F12)

I would like to have a formula to count just when exist an ID if not will be "".

Here is the image help please!

CodePudding user response：

Try below formula-

 =COUNTA(IFERROR(INDEX($E$3:$K$18,,MATCH(A2,$E$1:$K$1,0))))

CodePudding user response：

This is the formulas I was looking for:

=IF(A4<>"", (D4/$B$2), "")