I am creating spreadsheet of data and referencing on another tab within the same worksheet. The primary cell is blank until updated with a value...so I am trying to figure out how to write the formula to be blank until the primary cell has a value entered. Trying to avoid a zero from showing in the reference until the primary cell is updated with actual value. Any ideas?