Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2021, 03:59 AM
Jules90 Jules90 is offline How to select non-adjacent values in separate worksheets to include in formulas? Windows 8 How to select non-adjacent values in separate worksheets to include in formulas? Office 2013
Novice
How to select non-adjacent values in separate worksheets to include in formulas?
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Question How to select non-adjacent values in separate worksheets to include in formulas?

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
Reply With Quote
  #2  
Old 09-10-2021, 05:56 AM
wiganken wiganken is offline How to select non-adjacent values in separate worksheets to include in formulas? Windows 10 How to select non-adjacent values in separate worksheets to include in formulas? Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

I assume you are holding down the 'Ctrl' key whislt selecting multiple cells?
Reply With Quote
  #3  
Old 09-10-2021, 07:16 AM
Jules90 Jules90 is offline How to select non-adjacent values in separate worksheets to include in formulas? Windows 8 How to select non-adjacent values in separate worksheets to include in formulas? Office 2013
Novice
How to select non-adjacent values in separate worksheets to include in formulas?
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to select non-adjacent values in separate worksheets to include in formulas? Copy data from 2 external files into separate worksheets of a third file kevinbradley57 Excel Programming 2 05-25-2018 01:12 PM
How to select non-adjacent values in separate worksheets to include in formulas? Include multiple (but varying in number) Excel rows in each separate email mrjimi Mail Merge 3 12-10-2017 09:45 AM
Insert Row with Command Button Include Formulas and Merged Cells TileGal Excel Programming 12 08-30-2017 06:15 AM
How to select non-adjacent values in separate worksheets to include in formulas? Adding adjacent cells and having the sum appear in two separate places Seamus Sean Excel 4 12-11-2016 10:34 PM
How to select non-adjacent values in separate worksheets to include in formulas? Counting only the unique names in 3 columns on separate worksheets. Ryga38 Excel 1 04-15-2016 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft