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

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

Re: Sum product formula with conditions

From "Peter T" <askmy@email.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Sum product formula with conditions
Date 2019-07-22 12:25 +0100
Organization A noiseless patient Spider
Message-ID <qh46et$8hs$1@dont-email.me> (permalink)
References (17 earlier) <qh1hpe$ri2$1@dont-email.me> <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>

Show all headers | View raw

"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

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