PRESS RELEASE: Cassidy Jakovickas, CPA of Fresno, CA Appointed to Intuit’s Accountant Council

Select Panel Advises on Products and Services that Accountants and Their Clients Want Most             FRESNO, CALIFORNIA – June 4, 2019 –Today, Intuit, Inc (Nasdaq: INTU) announced that Cassidy...

Beyond The Numbers: What We’ve Been Reading

Although our team loves using numbers and spreadsheets to help our clients make the best financial decisions, we also enjoy reading great books. Staying well read on both fiction and non-fiction books helps us hone our imagination and introduces us to new, sometimes...

Looking Back At April

It’s hard to believe that we’re at the end of April, but it’s true! This month, we helped our clients wrap up another great (and busy) tax season. There was, as always, a lot of paperwork, emails, and nail-biting involved in the days preceding April 15, but that’s all...

5 Last-Minute Tips For Filing Taxes in 2019

Well, April 15 is almost here, and the tax-related panic is thick. If you haven’t filed your 2018 tax paperwork and are rushing to get your taxes in by the deadline, we’ve decided to give you some last-minute tax advice that will hopefully help ease your stress....

An Introduction To Cybersecurity for Business Owners

Keeping your sensitive business and customer data secure has never been more critical. Whether you are a small business or a national corporation, you can't relax your defenses against those criminals seeking to take advantage of lazy cybersecurity policies. Virtually...

March News Roundup

Wow! It seems like we just started March and we’re already moving into April! As we move into the final stretch of tax season, we’re recapping this month’s news for you, just in case you missed it amid the tax-related hubbub. MBS Accountancy: November Review This...

4 Key Changes To Depreciation Under The TCJA

As the Tax Cuts and Job Act (TCJA) continues to be unraveled by tax professionals, it’s important to review the changes and their implications on business operations and tax strategies. In this article, we’ll highlight TCJA’s changes to first-year bonus depreciation,...

3 Ways A CPA Can Make Your Business Successful

It can often seem unnecessary to hire a certified public accountant (CPA) since bookkeepers and accountants are frequently believed to be the be-all-end-all for a business’ finances. However, there are certain advantages to having a CPA by your side. While we...

3 Myths You Shouldn’t Believe About Accountants

To a business owner, an accountant that helps make sense of business finances can seem like a godsend. Whether you’re just starting your business or are already established, having a great accountant by your side is a sure way to keep your business running smoothly....

3 Ways QuickBooks Apps Can Improve Your Business’ Efficiency

Over 5.6 million businesses use QuickBooks to streamline their business’ accounting. The eye-pleasing interface, streamlined workflows, and powerful automation that QuickBooks provides to these business owners are invaluable, saving them time and money. While...

Don't let Google Docs and SUMIFS Get You Down

Reading Time: 1 minute

If you’ve spent enough time trying to do Excel things in Google Docs, you might have run into this challenge: no SUMIFS.

An obscure Excel function, SUMIFS allows you to add together cells based on several sets of criteria. One problem: It isn’t recognized by Google Docs.

Instead, you can combine two functions: SUM and FILTER.

If you haven’t used it before, FILTER is a function that allows you to select only cells that meet certain criteria. The syntax is =FILTER(range, criteria1, criteria2, criteria3, etc).

For example, if column A has project names, column B has dates, and column C has project statuses, and I want to select all the names of projects completed before today, I might write =FILTER(A:A, B:B<TODAY(), C:C=”Complete”).

Now, what if instead of just selecting the names of projects, what I want is the total expenses (column D) associated with projects completed before today? I “nest” the FILTER function into a SUM function.

=SUM(FILTER(D:D,B:B<TODAY(), C:C=”Complete”).

And that’s how you get around Google Docs’ lack of SUMIFS!

Note: Google Sheets is replacing Google Spreadsheets and has SUMIFS. New documents created in Sheets can use SUMIFS, old Google Docs should use this.

More tips for Google Docs? Share in the comments!


Shared from