SumProduct but avoinding sum 2 times the same wrong cell

[drom]

Hi and Thanks in advance

I have a Column in a table

I am trying to sum how many of the cells in this table column are wrong, by Wrong Imean:

• The Cell Value is Empy
• The cell Value is <=1
• The Cell Value>=25
• The Cell Value is Text

rcA = range("A4:A500")

So I was trying to use in A2 the following Formula:

A2 =SUMPRODUCT(--((rcA="")+(rcA<=0))+(rcA>24)+(ISTEXT(rcA)))

But Since I can put Text in any cell of this range, eg: A4 = "Hello" this formula add 2 wrong possibilities for the same cell

• So A2 formula is Wrong

If any cell in rcA can be Empty, eg A4="", I get 2 wrong possibilities for the same cell , so once again this formula is wrong

Any Help ?

 

[Fluff]

How about

=SUMPRODUCT(--(((rcA="")+(rcA<=0)+(rcA>24)+(ISTEXT(rcA)))>0))