1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Referencing values on another sheet

Hi, Im quite new to excel and can't figure out how to reference values on another sheet.

I have some sums and countifs on Sheet 1 and they all total up to lets say 500. How do I get a cell on sheet 2 to display this number without just typing it myself?

submitted by /u/Intelligent_Let7166
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#another sheet
#reference values
#countifs
#sums
#Sheet 1
#Sheet 2
#cell reference
#total
#display number
#formula
#value
#cell
#data
#automate
#function
Referencing values on another sheet