View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default 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.