View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
 
Posts: 88
Default 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