Assigning cells to groups which will pull data
Hello all, happy Thursday!
I am using Google Sheets so please remove if this is not allowed.
I am building an excel sheet to track my home networking. One of my sheets on my google sheets file is my "Rack Mount Unit" which holds my ideal setup for my Rack Cabinet. in this sheet, I have a "Total Est. Wattage in Unit" cell for which I would like to be able to estimate the wattage of my unit for power consumption purposes. I have another sheet called "Power Management" which will list a device, a group that it is assigned, and the est. watts it uses.
What I would like to do is go to my Rack Mount Unit sheet and insert a device into one of the desired spaces and give that cell in which the unit is inserted a value taken from the Power Management sheet. Then, I want to take that value and SUM it to the Total Est. Wattage in Unit cell in the same sheet.
Is there a way to assign a value connected to a group to a cell (which will not have a value, but a text shown on the cell), and have a SUM function pull the data?
Pictures included for reference, and link to view the google sheet included as well.
https://docs.google.com/spreadsheets/d/1Bk0CLKtCdtvCjwhfUXrlnS0CMywDh88N_1ll6L4_v0U/edit?usp=sharing
[link] [comments]
Want to read more?
Check out the full article on the original site