How do I Count a Range of whole-numbers / integers only?
J Jarek Kujawa Nov 25, 2008 #2 provided there are no empty cells in A1:A10 try: =SUM(IF($A$1:$A$10=INT($A$1:$A$10),1,)) this is an array formula so insert it with CTRL+SHIFT+ENTER
provided there are no empty cells in A1:A10 try: =SUM(IF($A$1:$A$10=INT($A$1:$A$10),1,)) this is an array formula so insert it with CTRL+SHIFT+ENTER
B Bernard Liengme Nov 25, 2008 #3 To count how many values in a range are integers =SUMPRODUCT(--(B21:B25=INT(B21:B25))) which is not an array formula best wishes
To count how many values in a range are integers =SUMPRODUCT(--(B21:B25=INT(B21:B25))) which is not an array formula best wishes
