Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SUMIF with OR condition

Options
tdade
tdade ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi. We have a calculation that will total various costs based on a manager. It works fine if we only need to include costs for a single manager. However, it doesn't work if we want it to total costs that might be related to more than one manager. We're using an OR condition when checking for the manager. Can you please help?

Here's what we're using:

=SUMIFS([Estimated Cost]:[Estimated Cost], [Spend Aprvd]:[Spend Aprvd], "1", Manager:Manager, ("Bob Smith" or "Jane Doe"), Quarter:Quarter, "Q4FY18 (May-Jul)")

Tags:

Comments

This discussion has been closed.