Thread: Text vs Number format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 380
Default Text vs Number format
=SUMPRODUCT(--B5:B10)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Curtis" wrote in message
...
Is there a way to add both text and numers formats together using
sumproduct?


Reply With QuoteReply With Quote