View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default SUMIF, wrong result, strange behaviour

I never would have, either.

It's scary how many things I trust without double checking <vbg.

Werner Rohrmoser wrote:

Hi Dave,

yes I've made some tests with 15 and more digits with and without
alpha-signs
and the result is, that only 15 digits are recognized, if the
expression contains only numbres.
Never thought of that.

Thank you.

Werner


--

Dave Peterson