# Sumifs with range

Options

Hi,

Refer to below, trying to get total sum of certain items.

Scenario : Sum numbers from the column, Color, if the column, Fruit is "Apple".

=SUMIFS([color]99:[color]104), fruit99:fruit104, "Apple")

• Options

ahhh. it works! thanks heaps!

• Options

Bumping up.

Is there a way to achieve the same using "children". Range will always be under the children level.

Instead of specifying row numbers, can we have a formula that covers all rows under children level?

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Genius!

This works!

```=SUMIFS(CHILDREN(color@row), CHILDREN(Fruit@row), "Apple")
```

The other one didn't work. But I can use above.

Thanks again~~~

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Actually This also works.

99 should be the specific parent row number. =D

```=SUMIFS(CHILDREN(color99), CHILDREN(Fruit99), "Apple")
```

• ✭✭✭✭✭✭
Options

Yes, both should work.

If possible I prefer the @row because you don't need to think about the row numbers and it takes less processing when something changes.

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!