I am working on a spreadsheet that is using the sumif formula however when populating the formula, the range flips from a cell range to a name that is not noted in the range that is being selected. Please see the attached for an example. I am trying to replicate this in another document but...
