Thread: Conditional Count, Countif Problem

Hi all

I am having the worst time trying to figure out, what I thought would be a simple function!!

I need to have a count of how many cells have .5 in them and how many do not, whole numbers.

I would like to have one formula to count all whole numbers, ex: 1,2,5,10, etc. And another formula to count all numbers that end in .5.

So if I have cells that contain: 1.5,2,0.50, 4...My whole number count is 2 and my .50 count is 2.

Thanks for any help and keeping me from pulling my hair out

One way to count integers:

=SUMPRODUCT(--(INT(A1:A5)=A1:A5),--(A1:A5<>""))

And, to count numbers ending in .5:

=SUMPRODUCT(--(A1:A5-INT(A1:A5)=0.5),--(A1:A5<>""))


Regards

Thanks for the rep.