Tuesday, February 26th, 2013
Written by Jane Hames.
Last week, one of my Excel workshop participants said they were confused when looking at Excel formulas with quotes, exclamation marks, colons and commas. I thought that my response was worth sharing as I’m sure he’s not the only one to be confused by this.
The formula below, is calculating the average of the values in cells in a different WORKBOOK across two different WORKSHEETS.