NEW

A Guide To Form 990 For Tax-Exempt Organizations

What is Form 990? Although many nonprofit organizations are exempt from paying federal taxes, the IRS requires tax-exempt organizations to file Form 990 for informational purposes. The IRS uses this informational return to determine whether you're still exempt from...

5 Critical Tax Tips For Nonprofits in 2019

No one enjoys filing taxes, but it can be especially problematic for nonprofits. Many nonprofits focus on their cause so much that they neglect proper organization. As a result, they deal with disorganized records and systems, and a lack of clarity around tax issues....

THE SMART BUSINESS OWNER’S LIST OF TAX DEDUCTIONS

For a business owner, taxes can be overwhelming and cumbersome. Tax deductions allow you to save thousands of dollars each year on your taxes and make tax filing a much more bearable experience. In this post, we'll list some of the tax deductions you can use to...

The Smart Business Owner’s List Of Tax Credits

One of the best ways to cut costs as a business owner is to take advantage of all the tax deductions and tax credits for which you're eligible. As a business owner, you're concerned with the bottom line--increasing your net profits. That probably means you spend most...

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...

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 neworganizing.com

Previous

Next