Eliminate Overlapping Entries
Select the 2 cells.
Go to the formula bar and type in
=sum_ovlp
Then press the three keys (Cntl, Shift, Enter) simultaneously
instead of simply pressing Enter.
You stated the R1C1 procedure correctly.
There is more info at Help Array formula.
|