Kurt Russell: (laughs) Lindsay, good to see you! Look, I know we're both enjoying a night out, but let's take a moment to talk about something super interesting. Ever heard of Microsoft Excel?
Lindsay Lohan: (giggles) Excel? Seriously, Kurt? What's next, you gonna teach me to be an accountant or something?
Kurt Russell: (chuckles) No, no, nothing like that. But Excel's got this cool function called AGGREGATE. It's like a Swiss Army knife for numbers, alright?
Lindsay Lohan: I can barely remember my lines these days, Kurt. And you want me to do math?
Kurt Russell: Haha, I promise it's easier than remembering lines for a Tarantino film. So, the AGGREGATE function lets you do all sorts of calculations without being thrown off by errors or hidden data.
Lindsay Lohan: (sips a drink) Mmm-hmm. You lost me at "calculations," but keep going, Mr. Spreadsheet.
Kurt Russell: Alright, let's say you've got a list of your movie earnings, but some of the numbers are messed up because, well, it was a wild night.
Lindsay Lohan: (laughs) Oh, I've had a few of those.
20,000,000
30,000,000
#N/A
#REF!
40,000,000
Kurt Russell: Normally, if you try to average these, Excel would give you an error because of those nasty "#N/A" and "#REF!" things. But AGGREGATE just shrugs it off like it's no big deal.
You'd use it like this: =AGGREGATE(1, 6, A1:A5)
Lindsay Lohan: What are those numbers? Is this Bingo?
Kurt Russell: Haha, not quite. The '1' stands for "AVERAGE," and the '6' tells Excel to ignore errors. And 'A1:A5' is just the range of cells with your movie earnings. So, it would give you the average of the good numbers: 30 million!
Lindsay Lohan: Wow, you make it sound almost cool.
Kurt Russell: Trust me, once you get the hang of it, it's as fun as stunt driving in 'Death Proof.'
Lindsay Lohan: (takes another sip) If you say so, Kurt. Now, how about another round?
Kurt Russell: Sure thing, but remember, if you're trying to calculate how many drinks you've had, AGGREGATE won't help you ignore those! Cheers!
Lindsay Lohan: (laughs) Cheers, Kurt!