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

Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…