This might be an easy question to some but I am completely lost so I would really appreciate any help out there!

```
        A      
  1    10
  2    20
  3    30
  4    40
  5    50
  6    60
  7    70
  8    80
  9    90
 10   100

```

Of course my actual work spreadsheet is a lot more complicated than the chart above but the logic I am trying to figure out is this (using array formula):

=SUM(IF(LEN(A1:A3,A8:A10)>0,1)) Control+Shift+Enter I can an error--- I want to write a cell range/reference that **completely ignores** A4:A7 (40, 50, 60, 70). (This comma is not working when it comes to combining 2 cell ranges that are split.)

**Can someone please help me write a cell range/reference that skips the mid-section of the chart! I feel like using OFFSET or INDEX can somehow accommodate the need but I am so lost.**