Need more detailed info about this:

I wanted to use an indirect reference from another sheet just for the column G in the first piece of the formula, leaving the row references of 3:189 intact.