=SUM(N(OFFSET(A1,0,SMALL(IF(B1:L1<"",COLUMN(B1:L1 )),{1,2,3})-1)))=SUM(N(OFFSET(A1,0,LARGE(IF(B1:L1<"",COLUMN(B 1:L1)),{1,2,3})-1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rich" wrote in message
...
I have multiple rows of data where I want to add the first three entries in
each row and compare the total to the last three entries in the row.
However
some of the rows have blank fields so some rows will have differently
spaced
first and last three entries. If there are less than six entries then the
row
is invalid

Here is an example

A B C D E F G H I J K
1 5 6 8 4 2 5 7 8 3 1 2 1st 3 = 19,
last 3 = 6
2 - 3 4 2 - 4 4 - 8 9 3 1st 3 = 9,
last 3 = 20
3 4 - - 8 7 - 5 6 - 2 - 1st 3= 19,
last 3 = 13
4 - 1 2 4 - - - 7 2 - - invalid

So I need a couple of fomulas that add the frist three and last three of
any
list of data


--
Rich