Thread: Sumif problem
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Sumif problem

A number isn't stored with a leading 0, so you would have to search for
,"5*"

--
Regards,
Tom Ogilvy

"GregR" wrote in message
oups.com...
The entry is stored as 05-45-000-000-000 and your formula works. I was
just musing, if it was a number, what adjustment would I have to make.
TIA

Greg