On Nov 24, 7:39*pm, Anthony wrote:
That works, but i think i have found an even more
efficient method:
=MAX( MAX( sum(A1:A5), sum(A7:A11) ) - sum(A13:A17), 0)
It seems to work OK from my initial tests.

It certainly is not the same as your original array formula in
general, unless there is something about your data that you have not
explained. Consider the following random data:

Row Data
1 114
2 144
3 126
4 142
5 182
6
7 172
8 100
9 120
10 100
11 100
12
13 50
14 50
15 50
16 50
17 50