nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

SUM cells in a row

Lisa Hallowell

I am trying to add values within cells in a child row that contain links to other sheets ... getting Total: 0 ... tried the below formula with no success ... any help would be soooo appreciated!

="Total: " + SUM(CHILDREN(Name2, Name17)

Comments

Jess Price

Try changing SUM to COUNT

Christine Oakes

Add one more close parenthesis at the end of your column.

="Total: " + SUM(CHILDREN(Name2, Name17))

J. Craig Williams

I'm not sure either of those is the correct answer.

"add values" implies SUM not COUNT.

The System will (usually?) add that last paranthesis as an auto-correct (it adds both if needed) but without warning you.

You formula is looking at the CHILDREN of row 2 and the CHILDREN of row 17.

If row 2 and row 17 are not parents, then the sum will be 0.

Are you trying instead of sum the values of row 2 THROUGH row 17?

That would be this:

="Total: " + SUM(Name2:Name17)

A screen shot would make it easier to help.

Craig