count decimal nos in a range

Hi all!

i'm using following formula in column"B" to find decimal nos.

=IF(ISNUMBER(FIND(".",A1)),"Decimal","Whole")

after this i just use simple countif function to count decimal in column C.

=COUNTIF(B1:B10,"decimal")

i want to know how can combine these two formulas into one that return only count of decimal number without using helper column.

regars

maybe like this:

Counting the decimals in B1 to B10:

=SUMPRODUCT(--(MOD(B1:B10,1)>0))

identifying the decimal in B1:

=IF(MOD(B1,1)>0,"decimal","integer")