Scratch that, the array formulas work. I forgot to trim out the leading
space. That's my error.

But still, why can't we force the argument to be looked up as text?

"Rif" wrote:

That still fails. :( In fact, I tried an array formula the minute I could
but I didn't want to bog the box down. Either array formula method I use
does not see the extra decimal places (even though it's text).

It's annoying and it won't go away unless I resort to VBA. :/


"daddylonglegs" wrote:


Try using SUMPRODUCT insted of SUMIF, i.e. for a count

=SUMPRODUCT(--(A1:A10=".0"))

or for a sum

=SUMPRODUCT(--(A1:A10=".0"),B1:B10)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564040