=COUNT if and frequency

[xxsalahxx]

Hello I am using the formula below to count numbers in column A ignoring any duplicate numbers. I would like to add a part to this to also pick up any blank cells from H2:H1000. Is there a way around this?


=COUNT(IF(FREQUENCY('3a6'!A2:A1000,'3a6'!A2:A1000),'3a6'!A2:A1000))
Thanking you for any help in advance.

 

[Aladin Akyurek]

Why are you duplicating this question of your earlier thread?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1047949-count-if.html#post5031166

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).