Hi,

Please can anyone help with a series of array formulas, I receive data
from a scheduled incident report, which looks a bit like the following:

Group Sub GP Duration < 1hr Duration 1-2hrs Duration > 2hrs
A 0 0 2
5
A 1 0 3
0
A 1a 5 0
12
A 2 9 0
15
B 0 1 1
11
B 1 0 0
0
B 1a 2 1
0
B 2 0 2
1

The report I receive is normally contains about 2000 groups and approx
25 more duration columns so I need something set up where i just paste
the report into a spreadsheet and it calculates:

All Group totals ie Group A, including all sub groups and all
durations, so for the above data the result would be: Group A = 51
incidents Group B = 19

All sub group totals, so again for the above data the result would be:
GroupA Sub Group 0 = 7
Sub Group 1 = 3
Sub Group 1a = 17 etc

Any help would be greatly appreciated

Thanks

flick.