How to select non-adjacent values in separate worksheets to include in formulas?

[Jules90]

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

[wiganken]

I assume you are holding down the 'Ctrl' key whislt selecting multiple cells?

[Jules90]

Yes, I'd been holding down the Ctrl key, but when it came to the second worksheet, I was clicking on the relevant cells but forgetting to add the comma after each value when it appeared on the formula bar. I've got it to work out now. Thanks.

Well to see I'm a novice!! Cheers