Hi, Mark,
did you try using SUBTOTAL (see menu data)
if that's impossible how would the SUM-formula-cells be recognized ?
if there are no other values involved, you could just total the entire column and divide by 2
N O
1 VALUES
2 1
3 2
4 3
5 SUM 6
6 NEXT RANGE
7 5
8 4
9 SUM 9
10
11 TOTAL SUMS 15
test
[Table-It] version 06 by Erik Van Geit
Code:
RANGE FORMULA (1st cell)
O5 =SUM(O2:O4)
O9 =SUM(O7:O8)
O11 =SUM(O2:O9)/2
[Table-It] version 06 by Erik Van Geit
kind regards,
Erik
EDIT: alternatively (using same sample data)
=SUMIF(N2:N9,"SUM",O2:O9)