Apologies if this is already on here, but my searches came up empty with regards to what I need here. This should be pretty basic, I'm just hitting a wall. The straight forward example of what I need is to run a formula in cell B1 that references the content in A1 and based on a criteria plugs...