Hello,
I have a really primary problem, where I need simple syntax for.
In my excel-sheet I have defined several groups of data, by defining different rows to a name. Group 1 = whole rows 2, 6, 9, ... ; Group 2 = rows 1, 3, 19, ... and so on.Now I want to do calculations with only numbers out of one column from a certain group.
How is this basic syntax done? I can't find it nowhere, but I think it must be possible.

So for example my group1 is =Sheet1!$43:$174;Blad1!$9:$22 and I want to use all the numbers in column Q from it.
What is the syntax to sum them? =sum(?)

Thanx in advance.