Summarization Formula Not Working

RBrewster

I'm trying to create a summary that adds the number of households (HH) for projects in a Construction status. Is it my formula or is this not possible in SS?

Christian Graf

Hello @RBrewster,

It looks like you are trying to use sum and an if statement to make your formula.

Smartsheet has a formula that combines the two called SUMIF(). The following formula should help you achieve your desired result.

=SUMIF([Stage]:[Stage], "Construction", [Homes-Curr]:[Homes-Curr])

Hope this helps!

-Christian