Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers
SPR
SPR
Nov 2019
10:09am, 28 Nov 2019
29,718 posts
  • Quote
  • Pin
SPR
SUMPRODUCT seems to be the answer.
exceljet.net
Diogenes
Diogenes
Nov 2019
10:09am, 28 Nov 2019
42,813 posts
  • Quote
  • Pin
Diogenes
(What Um said)
um
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
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
GregP
Nov 2019
10:31am, 28 Nov 2019
116,403 posts
  • Quote
  • Pin
GregP
That double negative thing is new to me, also
um
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
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
GregP
Nov 2019
11:37am, 28 Nov 2019
116,412 posts
  • Quote
  • Pin
GregP
And EXACT is bleating about insufficient arguments
um
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
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 --

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,000 Fetchies!
Already a Fetchie? Sign in here