Perhaps the "dreaded space bar" has been touched

=SUMPRODUCT((LEN(TRIM(M1:M21))0)*1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gotroots" wrote in message
...

The following formula returns a total of 53 when in fact it should be 39

=COUNTA(AL10:AL8002)+'other additions'!AK5

puzzled