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
Last edited by sheryar; 12-12-2009 at 05:41 AM.
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")
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Hi!
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks