Hi there,

I’m having trouble selecting non-adjacent values, on different worksheets in the same workbook, to enter into a formula.

After selecting all the relevant cells on both worksheets and pressing Enter, it keeps resulting in a zero! I’ve read that you can make selections on separate worksheets to include in formulas, but I can’t seem to figure out how to do this.

Can anyone help me out with this? It would be greatly appreciated. Thanks in advance