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.

Formula for SumIf

Larry.Reece

Larry.Reece ✭✭

09/20/17 edited 12/09/19 in Archived 2017 Posts

need formula for adding total from column if it meets the criteria from another column

=sumif(Division4:Division16,LSG,[Q1 AOP]14:[Q1 AOP]22)

0 ·

Comments

Marcus Odum ✭✭✭✭

09/20/17 edited 09/21/17

https://help.smartsheet.com/function/sumif

0 · Share on Facebook Share on Twitter
ricki ✭✭✭✭✭✭

09/25/17

Are you saying you want the sum of the divisions where Q1 AOP in row 14 is equal to Q1 AOP in row 22?

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Project Intake form in one workspace updated the Intake sheet in another workspace
Hope everyone is doing well. I would appreciate any insights you may have. I used the Project Management Template (PMO) to create an new workspace. Did this by saving this folder structure as NEW and called it MS Onboarding Lite. PMO structure: MS Onboarding Lite The first time I used the PMO to create a workspace was for…
Help with Average Formulas
Hi! I am trying to calculate a 3 months, 6 months and 1 year averages of my team utilization percentage. Each team member is a row and then each month is a column. The utilization percentages are coming from other sheets. Thank you in advance!
Copied Smarsheet as new, now Conditional Formatting will not work at all
I copied a Smartsheet and changed some of the column headers. I deleted all the Conditional Formatting because it no longer applied. Then when I set up new Conditional Formatting, very simple - if this cell says YES, make the row green - it will not work at all.