Josh Aharonoff (Your CFO Guy)

🔍 Financial Statements CONNECTIONS

"Name the 3 most important links between your financial statements..."

Can't do it? Don't worry.

After reading this, you'll never forget them.

📩 Join our newsletter and get instant access 👉 yourcfoguy.kit.com/financial-statements-connection…

Time to connect the dots 👇

➡️ INCOME STATEMENT → BALANCE SHEET: THE MONEY TRAIL

Remember that friend who tells everyone about your spending habits? That's your Income Statement talking to your Balance Sheet.

When Money Rolls In (Let's say a $10,000 sale):

• Income Statement: "Look who just made a sale! 🎉"
• Balance Sheet responds with either:
• "Got the cash right here! 💰" (+$10,000 in Cash)
• "They promised to pay... eventually 😅" (+$10,000 in Receivables)
• Retained Earnings: "Adding that profit to my collection 📝" (If profit margin is 30%, that's +$3,000)

When You Spend Money (Like $5,000 on inventory):

• Income Statement: "Don't worry, I'll expense this when it sells! 🤫"
• Balance Sheet shows your payment style:
• "Instant payment? Ouch, there goes our cash! 💸"
• "Buy now, pay later? Welcome to the Payables club 🎭"
• "New equipment? Time for the depreciation dance 💃"

➡️ BALANCE SHEET → CASH FLOW: WHERE'S THE MONEY REALLY GOING?

This is where we find out if you're actually rich or just "Instagram rich" 😉

The Working Capital Saga:

• Inventory Example ($20,000 purchase):
• Balance Sheet: "Look at all this inventory! 📦"
• Cash Flow: "Yeah, but we had to pay for that... 😭"
• The money's still yours, just not in spendable form!
• Receivables Reality ($50,000 sale):
• Income Statement: "Biggest sale ever! 🎉"
• Balance Sheet: "Cool, but where's the cash? 👀"
• Cash Flow: "Still waiting for that deposit... 🕒"
• Only when the customer pays do we celebrate!

The Debt Chronicles:

• Taking a $200,000 loan:
• Balance Sheet: "We're rich! (kind of) 🎭"
• Cash Flow: "Free money! (not really) 🎪"
• Income Statement: "Wait till you see these interest bills 😬"

➡️ CASH FLOW → INCOME STATEMENT: THE TRUTH DETECTOR

Working Capital Theater:

• Growing Business Scenario ($500K → $750K sales):
• Income Statement: "We're killing it! 🚀"
• Cash Flow: "But where's the money? 🤔"
• Balance Sheet: "Oh, it's here... tied up in receivables and inventory 🔒"
• Reality: More sales can actually mean less cash (mind blown 🤯)

➡️ The Big Connections

1. Net Income → Retained Earnings (The savings transfer)
2. Asset Purchases → Cash Flow → Depreciation (The big spender story)
3. Debt → Cash Flow → Interest (The cost of borrowing saga)
4. Revenue → Receivables → Cash (The "show me the money" journey)
5. Expenses → Payables → Cash (The "bills, bills, bills" cycle)

===

That's how financial statements work together to tell your business's story, sometimes it's a drama, sometimes it's a comedy, but it's always interesting!

Grab it here: yourcfoguy.kit.com/financial-statements-connection…

What's your favorite financial statement plot twist? Share your stories in the comments below 👇

1 day ago | [YT] | 80

Josh Aharonoff (Your CFO Guy)

Learn 80+ Excel Functions 🤯

These are the functions you NEED to know if you want to grow in your career

📩 Join our newsletter and get instant access 👉
yourcfoguy.kit.com/80-excel-functions?utm_source=s…


Let's walk through each section

➡️ LOOKUPS

These are really common, they return a value that you enter into your lookup formula

• VLOOKUP → Allows you to pull the value in the column of a range you specify
• HLOOKUP → Allows you to pull the value in the row of a range that you specify
• XLOOKUP → Allows you to pull both the row & column in a range you specify
• INDEX/MATCH → Similar to XLOOKUP, and combines two powerful functions
• GETPIVOTDATA → Allows you to lookup values in a PivotTable

➡️ DATES

These are formulas that allow you to work flexibly with dates

• DATE → Returns the date value after you specify the Year, Month, and Day
• NETWORKDAYS → calculates the net working days between 2 days
• DATEVALUE → calculates the date value of a cell formatted as text
• EOMONTH → returns the last day of the month after however many specified months from a cell
• EDATE → returns the date of a cell after X amount of months specified
• NOW → returns the current date & time
• TODAY → returns the current date
• MONTH → pulls the month value
• YEAR → pulls the year value

➡️ CONDITIONAL / BOOLEAN

These are also really popular, and allow you to return results that meet a specific true / false criterion

• IF → Returns one value if TRUE, another value if FALSE
• AND → returns TRUE if ALL conditions are met, otherwise FALSE
• OR → returns TRUE if ANY conditions are met, otherwise FALSE
• SUMIF(S) → sums a range if criteria is met
• IFERROR → returns a value if an error is found
• COUNTIF(S) → counts a range if a criteria is met
• AVERAGEIF(S) → averages values if a criteria is met
• ISBLANK → returns TRUE if a cell is blank
• ISNUMBER → returns TRUE if the cell is a number
• COUNTA → counts cells if there are values
• NOT → returns TRUE if a cell is not a criteria that you specify

➡️ SPILL FUNCTIONS

These are my favorite, they SPILL the values into other cells

• FILTER → Filters a range of data based on specified criteria
• UNIQUE → Returns a list of unique values from a range, removing any duplicates
• SORT → Sorts the contents of a range or array in ascending or descending order
• SEQUENCE → Generates a sequence of numbers as an array based on the specified parameters
• TRANSPOSE → Transposes the rows and columns of a range or array

===

There are many, many more functions that I couldn't list in this post.

But lucky for you, you can grab this resource entirely for free from my website.

Grab it here: yourcfoguy.kit.com/80-excel-functions?utm_source=s…

What is your favorite function?

Let us know in the comments below 👇

2 days ago | [YT] | 77

Josh Aharonoff (Your CFO Guy)

Learn all about Excel SPILL functions

👆 These are my favorite types of Excel functions

If you're not familiar with Excel SPILL functions, you are totally missing out.

Let's do a deep dive 🧑‍🏫

📩 Join our newsletter and get instant access 👉 yourcfoguy.kit.com/spill-functions?utm_source=soci…

➡️ What are SPILL functions?

SPILL functions in Excel let you enter one formula and automatically fill multiple cells with the results.

They essentially are dynamic arrays where the values SPILL into more than one cell.

➡️ Why are SPILL functions so valuable?

The biggest thing for me is the fact that you can create a whole range of data with just one formula…

and then reference the entire dataset by just pointing to the first cell in the SPILL range, and adding a #.

This is extra helpful in creating dynamic dropdowns and charts, since anytime your range extends, so will the dropdown or chart.

➡️ What are some common SPILL functions, and how can you use them in Finance & Accounting?

1️⃣ FILTER
=FILTER(array, include, [if_empty])

This one is really powerful, you can in essence return an entire table with just one formula, and however many criteria you want.

I like to create a filter on my general ledger with FILTER and return a subset of data

2️⃣ UNIQUE
=UNIQUE(array, [by_col], [exactly_once])

This may be my most commonly used SPILL function…

UNIQUE returns a list of unique values from the specified range.

This replaces the Data > Remove Duplicates button.

I like to get a UNIQUE list of customers / vendors from a list with this.

3️⃣ TRANSPOSE
=TRANSPOSE(array)

This one is convenient when you have a data range going horizontally… and want to flip it to vertically (or vice versa)

This replaces the need to copy and paste transposed

I use this one when creating a revenue amortization waterfall.

4️⃣ SORT
=SORT(array, [sort_index], [sort_order], [by_col])

This one is pretty self explanatory, you can easily sort a range.

I like to use this one in conjunction with the filter function to get back a range from my General Ledger that is both filtered and sorted

5️⃣ SEQUENCE
=SEQUENCE(rows, [columns], [start], [step])

This may be the coolest of all of them, with SEQUENCE, you can quickly generate a list over however many rows or columns.

I like to use this to create dynamic dates by wrapping the SEQUENCE function inside the DATE function (eg: DATE(2024,SEQUENCE(12),1) will create a list of 12 months with the first of each month)

===

SPILL functions are really powerful, and also help you understand how dynamic arrays work in Excel

Note that SPILL functions are only available in later versions of Excel, or those who have Microsoft 365.

While I've listed my favorite SPILL functions, there are many more.

Grab it here: yourcfoguy.kit.com/spill-functions?utm_source=soci…

What are some other SPILL functions you've seen?

Let us know in the comments below and join the discussion 👇

3 days ago | [YT] | 52

Josh Aharonoff (Your CFO Guy)

Finance & Accounting org chart 👩‍👩‍👧‍👧👥
Each company needs to have a “chain of command”…

with roles & responsibilities outlined for each member in the org.

But depending on your company size & industry, that can all vary…

Let’s take a look through some common Finance & Accounting org structures across different organizations:

➡️ MICRO

Typical company size: less than 10 employees

Most common approach here is to outsource everything for a few reasons:

• Odds are you don’t have enough work to justify a full time hire
• Even if you do have enough work to go around, odds are you need a bit of a junior hire, a bit of a senior hire, and a bit of a CFO
• Companies at this stage are often times cost conscientious, and you save money on payroll taxes & benefits when you hire an agency

Shoutout to Mighty Digits for outsourced Finance & Accounting!

➡️ SMALL

Typical Company size: 10-20 employees

At this stage, companies usually make their first in house hire as a senior role (manager, senior accountant / analyst), while continuing to outsource a junior role.

For those who have enough work to hire an in house junior role, it would typically be a staff accountant / analyst

➡️ MEDIUM

Typical Company size: 20-100 employees

Now comes some serious investing in Finance & Accounting

It’s common to start segregating your Finance & Accounting into both Accounting & FP&A…

with multiple layers of review at each department.

➡️ LARGE

Typical Company size: 100+ employees

There’s no limit now to where things can go with your Finance & Accounting…

most companies at this stage requires audits, and may have so much cash that they build out an entire treasury department.

Companies can still be privately held…or can even go public, in which case the need for resources & oversight would increase.

===

As mentioned above, a lot of dependent on your team size, and industry…

but the general idea is that the bigger an organization gets, the more need there is for oversight…

and the more need for DELEGATING work.

Each department has their own nuances in what is required…

and each industry requires a different investment in resources.

What have you seen in a Finance & Accounting org?

Let us know by joining in on the convo in the comments below 👇
Spill Functions

4 days ago | [YT] | 89

Josh Aharonoff (Your CFO Guy)

🔥 71 Excel Shortcuts That Will Change Your Life

Your keyboard is your most powerful ally in Excel…

but most people don't realize just how POWERFUL these shortcuts can be.

I'm about to share with you the 71 shortcuts that I use EVERY single day that have completely transformed my workflow.

📩 Join our newsletter and get instant access 👉 yourcfoguy.kit.com/71-excel-shortcuts?utm_source=s…

Let's dive in 👇

➡️ QUICK & EASY

These are the fundamentals that you NEED to master first. Think of these as your Excel foundation:

- F2 to edit cells (this is a game changer for quick edits)
- F4 to fix references (perfect for those formula adjustments)
- F9 to recalculate your worksheet
- Ctrl + T to create tables instantly
- Ctrl + C/X/V for your copy, cut, and paste needs
- Ctrl + Z/Y for undo/redo (because we all make mistakes!)
- Ctrl + B/I/U for text formatting

➡️ CELL FORMATTING

This is where the magic happens. These shortcuts will make your spreadsheets look PROFESSIONAL in seconds:

- Alt + W + V + G to remove gridlines (clean and sleek!)
- Alt + H + B + A for borders all around
- Alt + H + F + C to change cell colors
- Alt + H + A + C to align center
- Alt + H + M + C to merge and center

➡️ THE ESSENTIALS

These are the shortcuts that separate Excel PROS from amateurs:

- Ctrl + Arrow keys to jump between data points
- Shift + Space to select entire rows
- Ctrl + Space to select entire columns
- Alt + H + O + I for autofit column width
- Alt + H + O + A for autofit row height
- Alt + = for quick AutoSum (this one saves HOURS)

➡️ PASTE SPECIAL MAGIC

The paste special shortcuts are a GAME CHANGER for data manipulation:

- Alt + H + V + V for values only
- Alt + H + V + T to transpose
- Alt + H + V + F for formulas
- Alt + H + V + R for formats

➡️ OTHERS (THE HIDDEN GEMS)

These are the lesser-known shortcuts that will make you look like an Excel wizard:

- Ctrl + Shift + F3 to create named ranges
- Ctrl + Alt + F9 to recalculate ALL workbooks
- Alt + H + S + F to create filters instantly
- Ctrl + Shift + Space to select the entire worksheet

===

Here's the thing about Excel shortcuts...

They're not just about speed - they're about PRECISION and PROFESSIONALISM.

When you master these shortcuts, you're not just saving time...

You're transforming into a true Excel professional who can handle ANY spreadsheet challenge that comes your way.

🎯 Pro Tip: Start with 5 shortcuts and master them before moving to the next set. Rome wasn't built in a day, and neither is Excel mastery!

Grab it here: yourcfoguy.kit.com/71-excel-shortcuts?utm_source=s…

What's your favorite Excel shortcut?

Share it in the comments below 👇

5 days ago | [YT] | 101

Josh Aharonoff (Your CFO Guy)

20 Hidden Excel Shortcuts to INSTANTLY Boost Your Productivity 🧮

Wait...you're still using your mouse in Excel??

If you spend hours in spreadsheets like I do, you NEED to master keyboard shortcuts.

The gap between a 5 hour task and a 2 hour one often comes down to how efficiently you navigate Excel.

Let's break down 20 shortcuts that most Excel users don't know about 👇

NAVIGATION SHORTCUTS 🧭

Shift + Arrow Keys = Select text or cells

Hold shift while using arrows to select ranges without touching your mouse.

Ctrl + Arrow Keys = Moves to the edge of current data region

Jump instantly to the end of your dataset in any direction. I use this CONSTANTLY with large financial models.

Alt + W + F + F = Freeze Panes

Lock your headers in place with one combo. No more scrolling to see what column you're in.

Alt + W + W = Switch windows

Toggle between multiple Excel files without clicking through the taskbar.

SELECTION SHORTCUTS 📊

Shift + Space = Select entire row

Grab all data across a row instantly, for copying, formatting, or deleting.

Ctrl + Space = Select entire column

Same idea, but vertical. Select your whole column in one keystroke.

Alt + ↓ = Select drop downs

Opens dropdowns in filtered tables or data validation cells without clicking.

Ctrl + Shift + O = Selects comment cells

Finds every cell with a comment instantly, great for reviewing team feedback.

FORMATTING SHORTCUTS ✨

Ctrl + Shift + % = Apply percentage format

Instantly formats as a percentage and multiplies by 100. Perfect for margins and growth rates!

Ctrl + Shift + 3 = Format for number

Standardizes numerical formats across your reports instantly.

Alt + H + M + C = Merge & Center

Combines cells and centers the content. Great for headers.

Alt + H + A + N = Format currency

One of my FAVORITES, instant currency formatting with your default symbol.

FORMULA SHORTCUTS 🧪

Ctrl + ; = Insert current date

Drops today's date into a cell instantly. Great for timestamps.

Alt + = = Autosum selected cells

Why type =SUM() yourself? Excel guesses the right range for you.

Alt + Enter = Start a new line within the same cell

Add multi-line text without messing up your row heights.

EDITING SHORTCUTS ✏️

F2 = Edit the active cell

Jump into edit mode without double-clicking. Huge time-saver!

F4 = Toggle between absolute/relative references

Cycles through every reference type, no more typing $ symbols by hand.

Ctrl + D = Fill down (copy content from cell above)

Copy formulas or values down without dragging.

===

I've saved HOURS every week since mastering these shortcuts.

Which Excel shortcut do you find most useful? Any others I should include?

Share in the comments below 👇

6 days ago | [YT] | 74

Josh Aharonoff (Your CFO Guy)

The Top Finance & Accounting Abbreviations 👇
Study these and master the lingo!

➡️ CORE FINANCIAL STATEMENTS

These are your business storytellers in paper form:

P&L (Profit & Loss Statement) → Shows if you're making money

B/S (Balance Sheet) → Snapshot of what you own vs. what you owe

CFS (Cash Flow Statement) → Tracks where your cash actually goes

F/S (Financial Statements) → The complete financial story

OCI (Other Comprehensive Income) → Those sneaky gains and losses that bypass your P&L

➡️ KEY CONCEPTS YOU'LL HEAR DAILY

COGS (Cost of Goods Sold) → The real cost of selling your product

G&A (General and Administrative Expenses) → All those office expenses keeping lights on

AR (Accounts Receivable) → Money customers owe you

AP (Accounts Payable) → Money you owe vendors

PP&E (Property, Plant & Equipment) → The large physical assets you use to run your business (buildings, equipment)

NI (Net Income) → What's left after everything's paid

➡️ PERFORMANCE METRICS (The ones that make investors' eyes light up)

EBITDA (Earnings Before Interest, Taxes, Depreciation & Amortization) → Your earnings before the accountants get involved 😂

ROE (Return on Equity) → How efficiently you're using shareholder money

ROA (Return on Assets) → How well you're using everything you own

EPS (Earnings Per Share) → The number Wall Street obsesses over

OPEX (Operating Expenses) → Your daily running costs

TTM (Trailing Twelve Months) → Last 12 months' performance

➡️ VALUATION METRICS

P/E (Price-to-Earnings Ratio) → How expensive your stock is

D/E (Debt-to-Equity Ratio) → How much you're borrowing

WACC (Weighted Average Cost of Capital) → The cost of funding your business

EV (Enterprise Value) → What your business is really worth

FV (Future Value) / PV (Present Value) → Tomorrow's money vs Today's money

➡️ INVESTMENT ANALYSIS (The heavy hitters)

DCF (Discounted Cash Flow) → Predicting tomorrow's cash today

NPV (Net Present Value) → Is this investment worth it?

IRR (Internal Rate of Return) → Your real return rate

CAPM (Capital Asset Pricing Model) → How much return you should expect

ROI (Return on Investment) → The bottom line on any investment

➡️ STANDARDS & COMPLIANCE

IFRS (International Financial Reporting Standards) → How most of the world does accounting

GAAP (Generally Accepted Accounting Principles) → How America does accounting

SOX (Sarbanes-Oxley Act) → Because Enron ruined it for everyone

===

Which abbreviations do you use most often?

Share your favorites in the comments below 👇

1 week ago | [YT] | 132

Josh Aharonoff (Your CFO Guy)

12 Ways to present a P&L

1. 📔 ACCRUAL basis
❔ What it is → showcases income when earned, expenses when incurred
💡 Why it’s valuable → gives you a more practical understanding of what’s actually happening

2. 🤑 CASH basis
❔ What it is → showcases income when cash is received, expenses when cash is paid
💡 Why it’s valuable → simple to prepare / understand

3. 📂By CLASS
❔ What it is → showcases your activity based off of tags
💡 Why it’s valuable → using tags, you can add a 3rd dimension to your data

4. 🗓️MONTHLY
❔ What it is → showcases your information on a month to month basis
💡 Why it’s valuable → allows you to understand what’s happening over a short time window

5. 🗓️ QUARTERLY
❔ What it is → showcase your information on a quarter by quarter basis
💡 Why it’s valuable → allows you to identify trends & seasonality across the year

6. 🗓️ ANNUAL
❔ What it is → showcase your information on an annual basis
💡 Why it’s valuable → helpful in seeing where you’ve been, and where you’re going

7. % of REVENUE
❔ What it is → divide each section of your P&L by revenue
💡 Why it’s valuable → helps you understand what are the biggest drivers of your business activity

8. 📁 By CATEGORY
❔ What it is → showcase your P&L based off of cost type, or summary groupings
💡 Why it’s valuable → gives you a zoomed out view of what’s happening, allowing you to drill deeper where necessary

9. 👥 By DEPARTMENT
❔ What it is → showcase your activity based off of each department’s activity
💡 Why it’s valuable → allows you to understand what area of your business is consuming your resources

10. 🕧 vs LAST PERIOD
❔ What it is → showcases your activity as compares to last period
💡 Why it’s valuable → understand how you are progressing each month

11. ❓ vs BUDGET
❔ What it is → show what happened vs what you thought would happen
💡 Why it’s valuable → gives you confidence & insights into where your assumptions are accurate vs need adjustment


12. 📅 vs LAST YEAR
❔ What it is → compare your results against the same time period last month
💡 Why it’s valuable → allows you to compare seasonality, and how much you’ve grown in 12 months

Those are my 12 ways to present a P&L!

What are some other ways?

Join us in the discussion in the comments below 👇

1 week ago | [YT] | 131

Josh Aharonoff (Your CFO Guy)

🚧 The LAMBDA Function

Excel has thousands of functions.

But what if none of them do EXACTLY what you need?

What if you could build your OWN function, tailored specifically to your work?

No coding required. No complex VBA. Just pure Excel magic.

Let me introduce you to LAMBDA…

➡️ WHAT IS LAMBDA?

Think of LAMBDA as your own personal Excel function factory.

Just like SUM or AVERAGE, except built entirely around what YOU need.

Take any calculation, no matter how complex, and turn it into a simple, reusable function.

Imagine never rebuilding that nested IF statement again.

➡️ THE BASIC SYNTAX

Let's break down how LAMBDA works.

=LAMBDA(parameter(s), calculation)

That's really it. Here's what each part means:

💡 Parameters, your input values
💡 Calculation, the formula using those parameters
💡 Returns, a single value or an entire array

The best part? Build it once, and you use it forever.

➡️ HOW TO SAVE AS A NAMED FUNCTION

Here's your step by step guide to building your first LAMBDA function.

1️⃣ Start by building your custom formula for whatever you need to calculate.

2️⃣ Go to the Formulas tab and click Name Manager. This is where it happens.

3️⃣ Click New to add a fresh named range.

4️⃣ Give your function a name you'll actually remember later.

5️⃣ Drop your LAMBDA function into the formula box.

6️⃣ Click OK to save it.

7️⃣ Test it out. Apply it to any cell you want.

8️⃣ Watch it work perfectly across your entire worksheet.

➡️ THE BENEFITS

Why should you care about LAMBDA? Here's why.

🎯 Reusable custom functions, build once, use forever
🎯 No VBA required, pure Excel formulas
🎯 Simplified complex calculations, easier for anyone to understand
🎯 Easy to share and maintain, great for team collaboration

➡️ REAL WORLD APPLICATIONS

Here are a few examples I actually use every day.

📊 SQUARE FUNCTION =LAMBDA(x, x^2)

Perfect for:

• Calculating areas
• Geometric calculations
• Statistical analysis

Example, =SQUARE(5) returns 25.

💰 ADD TAX FUNCTION =LAMBDA(price, price * 1.2)

Perfect for:

• Quick tax calculations
• Pricing tables
• Invoicing

Example, =ADDTAX(100) returns 120.

👥 FULL NAME FUNCTION =LAMBDA(first,last,CONCAT(first," ",last))

Perfect for:

• Customer lists
• Employee databases
• Mail merges

Example, =FULLNAME("John","Doe") returns "John Doe".

➡️ PRO TIPS

A few things I've learned along the way.

💡 Keep your function names descriptive
💡 Document your parameters clearly
💡 Test with different inputs before you save
💡 Share your functions with your team
💡 Build on basic functions to create more complex ones

===

The beauty of LAMBDA is that you can start small and build up from there.

Create one custom function today, add another tomorrow, and soon you've got your own personal Excel toolkit.

Which function will you create first? Share your ideas below 👇

1 week ago | [YT] | 87

Josh Aharonoff (Your CFO Guy)

6 Ways to SUM in Excel ➕

Summing data is one of the most common things you'll do in Excel.

But there's a lot more available than just adding values together.

Here are 6 different ways to sum in Excel, each with its own strengths.

1️⃣ =SUM

Nothing fancy here.

It's the simplest way to add values together.

Worth knowing, you can separate your values with either a colon or a comma.

2️⃣ =SUMIF

Now we kick it up a notch 👍

Here, you sum values only if they meet a specific criteria.

This one's popular because it blends an IF function directly into a SUM.

Pro tip: hit ALT + = at the bottom of a range to autosum everything above it.

3️⃣ =SUMIFS

Very similar to SUMIF, except now you can stack multiple conditions instead of just one.

I always reach for SUMIFS over SUMIF.

The syntax is a little different, but SUMIFS can do everything SUMIF does and more.

Honestly, this is one of my most used functions, especially when I'm summarizing a detailed P&L or Balance Sheet for a presentation.

4️⃣ =SUBTOTAL

This one's cool, and I didn't even know about it until earlier this year.

What's neat is that SUBTOTAL sums the cells with real values, while ignoring any cells that are already subtotals themselves.

So if you're building subtotals into a P&L, you can use the exact same formula for gross profit as you do for net income, without worrying about double counting.

5️⃣ =AGGREGATE

AGGREGATE is like SUBTOTAL, on steroids.

Instead of just ignoring other subtotal rows, you can choose to ignore error cells, hidden cells inside a filter, and a handful of other options.

What's great about both AGGREGATE and SUBTOTAL is you're not locked into SUM.

You can run AVERAGE, COUNT, MAX, and plenty more.

6️⃣ =SUMPRODUCT

Here's my favorite function in Excel, the one that fits almost any use case you throw at it.

The idea is simple.

Set your range as a table with both an X and Y axis, something SUMIFS really struggles with, then layer on whatever conditions you need.

This function is so good, I plan on doing an entire post on it by itself.

===

Those are 6 ways to sum in Excel.

Which one is your favorite? And which would you add?

Let us know in the comments below 👇

1 week ago (edited) | [YT] | 77