Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111054

Re: Sum product formula with conditions

From dpb <none@none.net>
Newsgroups microsoft.public.excel.programming
Subject Re: Sum product formula with conditions
Date 2019-07-22 07:29 -0500
Organization Aioe.org NNTP Server
Message-ID <qh4a6r$bas$1@gioia.aioe.org> (permalink)
References (18 earlier) <qh1ndq$t6h$1@gioia.aioe.org> <qh238j$r3u$1@dont-email.me> <qh2ar9$1l3m$1@gioia.aioe.org> <7fd5a021-46a0-41f3-98fb-733c96974011@googlegroups.com> <qh46et$8hs$1@dont-email.me>

Show all headers | View raw

On 7/22/2019 6:25 AM, Peter T wrote:
> "TIMOTHY" <jey.kumar87@gmail.com> wrote in message
>> Thank you Peter, dpb, and GS
> 
> Probably a bit more than you bargained for:)
> 
> dpb is of course right clarity is important, particularly when coming back 6
> months later. In typical use it's unlikely you'll notice any difference
> between N or -- (or similar) so go with whichever you prefer, but keep in
> the back of your mind if ever dealing with heavy calculation why they are
> not quite the same.
> 
> More importantly understand why it's needed, namely because Sumproduct
> treats any non-numeric array elements (after resolving) as zero. That's
> useful for text but we want any False/True as numeric 0/1
> 
> Peter T

And, thank you for taking the time to actually do the timings...I'd 
never'uve thunk N() could be such a dog...

--

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-14 21:15 -0700
  Sum product formula with conditions Alan Wong <alanwongwinglun.hk@gmail.com> - 2019-07-15 16:52 -0700
    Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-15 20:01 -0700
      Re: Sum product formula with conditions Roger Govier <rogergovier@gmail.com> - 2019-07-16 08:40 -0700
        Re: Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-17 07:46 -0700
          Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-17 11:34 -0500
            Re: Sum product formula with conditions GS <gs@v.invalid> - 2019-07-17 16:20 -0400
              Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-17 18:58 -0500
                Re: Sum product formula with conditions GS <gs@v.invalid> - 2019-07-18 11:53 -0400
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-18 11:29 -0500
                Re: Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-18 10:33 -0700
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-18 13:45 -0500
                Re: Sum product formula with conditions "Peter T" <askmy@email.com> - 2019-07-19 18:52 +0100
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-19 16:04 -0500
                Re: Sum product formula with conditions GS <gs@v.invalid> - 2019-07-19 19:56 -0400
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-19 19:08 -0500
                Re: Sum product formula with conditions "Peter T" <askmy@email.com> - 2019-07-20 10:34 +0100
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-20 07:47 -0500
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-20 08:50 -0500
                Re: Sum product formula with conditions "Peter T" <askmy@email.com> - 2019-07-21 12:20 +0100
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-21 07:56 -0500
                Re: Sum product formula with conditions "Peter T" <askmy@email.com> - 2019-07-21 17:18 +0100
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-21 13:27 -0500
                Re: Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-21 20:47 -0700
                Re: Sum product formula with conditions "Peter T" <askmy@email.com> - 2019-07-22 12:25 +0100
                Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-22 07:29 -0500
                Re: Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-22 20:32 -0700
            Re: Sum product formula with conditions dpb <none@none.net> - 2019-07-18 17:43 -0500
              Re: Sum product formula with conditions TIMOTHY <jey.kumar87@gmail.com> - 2019-07-19 07:41 -0700

csiph-web