Hi,

would you be so kind and assist me with updating my formula to not count empty cells?

=SUMPRODUCT(1/COUNTIF(G2:G51;G2:G51)*(J2:J51=N2))

I would like to have amount of unique values based on another criteria. Row G would be G2:G2000, however cells below G51 are currently empty and formula would show an error.

Thank you very much.