ExcelBanter - Text vs Number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text vs Number format (https://www.excelbanter.com/excel-worksheet-functions/116608-text-vs-number-format.html)

Curtis

Text vs Number format

Is there a way to add both text and numers formats together using sumproduct?

Bob Phillips

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?

All times are GMT +1. The time now is 04:32 AM.