Sum of Child Rows - Linked Text

Lisa Marie

Hi all!

Hoping the community can help me w/this one. 

I have a database in which various quantities of part numbers are listed based on what model the system is, etc. Each of the quantities is display text (a number, i.e. "6") w/a hyperlink to the listing of the part itself in a different sheet.

I'm trying to sum up each column of parts to show how many we have of each worldwide. For the life of me, I can't figure out how to SUM child rows - anyone have a thought?

Thank you!

Paul Newcome

The most basic way would be 

 

=SUM(CHILDREN())

 

or

 

=SUM(CHILDREN([Column Name]@row))

.

If you can provide more details as to the layout and setup and possibly some screenshots, we may be able to help you with a more specific solution.

Lisa Marie

Hi Paul,

Thank you! I believe my issue w/using that is that a linked number isn't recognized as a number, but rather as display text. I tried using VALUE, but I believe we're unable to use that in conjunction w/the SUM function.

 

Paul Newcome

Ah. My apologies. I missed that part the first time I read through your post. You will need to create a "Helper" column and use a VALUE function to convert it to a number.

 

=VALUE([Column Name]@row)

 

THEN you can use the

 

=SUM(CHILDREN([Helper Column]@row))