INDEX(($O$12,$O$16,,,1) returns a reference to the first area ($O$12)

INDEX(($O$12,$O$16,,,2) returns a reference to the second area ($O$16)

You can use this method in a SUMPRODUCT as:

=SUMPRODUCT(--SUBSTITUTE(T

The same approach will also work in a SUM formula with regular entry:

=SUM(--SUBSTITUTE(TEXT(IND

This approach is admittedly not very impressive for a non-contiguous range of two cells. It gets a lot more interesting if you expand it to non-contiguous columns of cells, such as in this thread:

http://www.tek-tips.com/vi

Brad