Sum of Child Rows - Linked Text

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!

Find more posts tagged with

Comments

Paul Newcome

The most basic way would be

=SUM(CHILDREN())

=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))

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…