
In the Vertices tab I have added a new column Amount (under Other column) and entered for each vertex a $amount. I have grouped my vertices by connected component.
Question: How to get a group total ?
In the group Tab, is there a way to add a 'Group Total' column that shows the group amount for each group (G1, G2, G3...) (ie sum of members value for each group) ?
Thanks


Coordinator
Feb 18, 2015 at 11:45 PM

Hello!
Thank you for the interest in NodeXL!
Perhaps this is a case in which Excel is the answer?
The =SUMIF() function does a good job of adding up the values associated with a particular label.
See example #2: http://support.office.microsoft.com/enus/article/SUMIFfunction5fd078dbe5f84726b08f74fd0064e7fe
But first we need to find a way to move the Group Vertices assignment to the Vertices worksheet, that requires another Excel feature =VLOOKUP().
See: https://support.office.microsoft.com/enUS/article/VLOOKUPfunctione2fba01b188c405787e2df6bb4075817
Regards,
Marc



Thanks Eric for your prompt answer. That put me on the right track. thans again.

