SUM?COUNTIF?SUMIF?

Eric Laitenberger

Eric Laitenberger ✭✭✭✭✭

07/06/22 in Add Ons and Integrations

Hello,

I would like add up number in the column if a other column =1 could you give me the formula please

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

07/06/22

You would need a SUMIFS.

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending Posts

Bridge Error: When field from the source sheet is blank
I've created a very simple workflow - copying data from one sheet to another when a row is added (just getting started). And I finally got the darn thing working - Yay!! BUT: I just got this error - because the date in the source sheet is blank. How do I set it so that if that date is blank (or any field, for that matter),…
Copy and Add by Criteria in DataMesh
We have the Data Mesh add on. I'd love to be able to "copy and add" (automatically add new rows from one sheet to another) based on certain criteria. In this way, everything added to the new sheet is filtered by what I want. In this way I can manage all my requests in one sheet, and have it copy to other sheets by client,…
"Please select a Target before configuring the Mapping" error in Data Shuttle
In Data Shuttle, I'm running into a "Please select a Target before configuring the Mapping" error on the Mapping page, but I've already selected a Target sheet. Mapping: Target: I ran into the error when creating a new workflow, so I went to an existing workflow to see if I'd run into any similar issues. I Next-ed through…

Help shape the future of Smartsheet.
Share your ideas and feature requests.