for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

SPR Nov 2019 10:09am, 28 Nov 2019 29,718 posts	Quote Pin SPR SUMPRODUCT seems to be the answer. exceljet.net
Diogenes Nov 2019 10:09am, 28 Nov 2019 42,813 posts	Quote Pin Diogenes (What Um said)
um Nov 2019 10:13am, 28 Nov 2019 1,431 posts	Quote Pin um Another 'who knew?' - that =sum(if(exact ...) needs to be terminated with CTRL SHIFT ENTER and excel wraps it in { } to make it an 'array' function. Never heard of this before, or found out (yet) how & what it does.
GregP Nov 2019 10:30am, 28 Nov 2019 116,402 posts	Quote Pin GregP Thanks guys. Want to avoid array functions if I can, but helpful+ so far. Actual mini-LOL about VLOOKUP in this context
GregP Nov 2019 10:31am, 28 Nov 2019 116,403 posts	Quote Pin GregP That double negative thing is new to me, also
um Nov 2019 10:38am, 28 Nov 2019 1,432 posts	Quote Pin um New to me: The double negative (aka "double unary") coerces TRUE or FALSE values to their numeric equivalents, 1 and 0. It's used in formulas where numbers are needed for a particular math operation.
GregP Nov 2019 11:11am, 28 Nov 2019 116,407 posts	Quote Pin GregP Isn't there an extraneous set of brackets on SPR's link?
GregP Nov 2019 11:37am, 28 Nov 2019 116,412 posts	Quote Pin GregP And EXACT is bleating about insufficient arguments
um Nov 2019 11:59am, 28 Nov 2019 1,433 posts	Quote Pin um Greg - yes, looks to be spare brackets in that link. =SUMPRODUCT(--(EXACT(A:A,"London"))) works for me on a small test. What's your example?
SPR Nov 2019 12:11pm, 28 Nov 2019 29,723 posts	Quote Pin SPR Um, you have the same number of brackets, you just have one ahead of EXACT instead of two ahead of --