worksheet function - Excel: Using ADDRESS to create Array Formula - Super User
I'm trying to replace the hardcoded references E13:E15 with relative references: =+SUM(LN(INDIRECT("E13:E15"))) I've tried variations of below, in cell e16, but nothing seems to work: =+SUM(LN(INDIRECT(ADDRESS(ROW()-3,COLUMN())&":"&ADDRESS(ROW()-1 ......
網址安全性掃描由 
提供
