Hello all and Happy 2014.
I have a list that grows and shrinks based on a condition as the list itself is based on this condition. The list is an array formula with a 'small' function (it is looking up another 'master' list). If we say the condition is color, here is what the list for 'blue' would look like;
1). Dogs - Blue - 2
2). Cats - Blue - 4
5). Giraffes - Blue - 1
10). Elephants - Blue - 2
11). Mice - Blue - 3
14). Rats - Blue - 3
16). Birds - Blue - 4
20). Fish - Blue - 1
Total: 21
But that same list, for 'red' will be a lot smaller;
3). Kanagroos - Red - 3
6). Frogs - Red - 5
Total: 8
- BUT, as I have tried to demonstrate, the 'Total' row is still accommodating all that space for the 'blue' condition (for which there were many more entries than for 'red').
How do I make the 'total' row automatically move up and down depending on how long the list is? Ideally, the total row should always appear one row below the last entry on the list...
Thanks in advance...
Bookmarks