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

Use Contain with And extension?
Hi, I'm trying to pull the correct tuition rate based on MS/M.S. or PhD status and if their department contains Engineering. This is my Active sheet. The formula I'm currently using: =IF(CONTAINS("Engineering", [Grad Field of Instruction]@row), 14750, 10400). So I thought adding the ADD Degree Program = M.S. MS, but unsure…
Grouping in reports does not show headers of the drop-down list
Hi I am a new user trying to test and see how much I can pull off from this amazing sheet. Well, I am trying to create a report with all the tasks for any given stakeholder. I am grouping the report based on the primary field that has values within a particular header as in the ss below: And, if you look at the report, it…
What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all, I'm looking for help with an index-collect formula. I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range. Below is the formula I currently have, which I know is incorrect. Any…