Sum product formula with conditions
"dpb" wrote in message
On 7/18/2019 12:33 PM, TIMOTHY wrote:
Thank you dbp & GS
You're welcome...eye-straining syntax like writing "--" just breaks my
brain to try to look at. :)
When there's a function for the express purpose to cast to numeric from
other types, why wouldn't anybody use it boggles the mind
I wouldn't want to discourage your use of the N function, however I would
suggest others new this to consider using the 'double unary' as more
efficient.
Just butting in ;)
unless it is a relatively recent introduction into Excel which I wouldn't
think likely.
Indeed not recent, 97 if not earlier
Peter T
|