Re: Help - array formula nightmare!!!!

It would make things a lot easier if you were to insert a new column C,
with a heading like "Total" in C1 and this formula in C2:

=SUM(D2:AE2)

(or however many duration columns you have). Copy this formula down to
row 2000.

Then in your summary *** you will need to list in column A all the
main groups that you have, i.e. CST, TAGS1, MNG1 etc. This forms the
upper table, and for the lower table copy the main groups down below,
leaving a gap of a few rows, then put the first of your 7 subgroup
codes in column B and copy down. Then highlight the main groups and
copy the list below itself in column A and put the second of your seven
subgroup codes in B and copy this down. Repeat this for the other 5
sub-group codes. You can then sort the tables so you will have
something like:

CST
MNG1
TAGS1

(gap)

CST 0
CST 1
CST 1a
CST 2
CST 2a
CST 3
CST 4
MNG1 0
MNG1 1
MNG1 1a
MNG1 2
MNG1 2a
MNG1 3
MNG1 4

Hope this helps for now - will return later after some lunch.

Pete

.