•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Assigning cells to groups which will pull data
Our take
Happy Thursday, everyone! I’m currently building a Google Sheets file to track my home networking setup, specifically focusing on my Rack Mount Unit. In this sheet, I want to estimate the total wattage for power consumption. I have a separate "Power Management" sheet that lists devices, their assigned groups, and their estimated wattage. I’m seeking a solution to insert a device in my Rack Mount Unit sheet that displays text while allowing a SUM function to pull the corresponding wattage from the Power Management sheet.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel seems to think cell isn't big enough so 2 digit number looks crazy, no adjustment fixes issueI have multiple sheets that add together to make a total on the first page. Easy. The numbers are small - 3, 5, 10, nothing big. On the totals sheet, all the two digit sums are wrapped so that they are very small. I do not have wrapped text on but when I DO wrap the text, it stops wrapping them BUT there's this giant space between the two digits like "1 0" for 10. I tried everything I could think of - rewriting the formula as a SUM function (rather than this sheet + this sheet + this sheet), making sure each cell is formatted as a number, running "text to column" on each column of data, switching the font, switching the font size, changing the column size manually, double clicking on the columns to have them auto size, turning off shrink to fit, turning on shrink to fit again after, playing with the alignment.... Does anyone know what is going on and how I can solve it? Adding images (w/ some edits for privacy for my company). Will include the formulas (both versions). https://preview.redd.it/6n05pqeer4og1.png?width=1654&format=png&auto=webp&s=64729e1558bfba595d7d043b18d777b3e33e4ecf https://preview.redd.it/ydydstbfr4og1.png?width=1664&format=png&auto=webp&s=27e3d7cd18c2c380a5cf1a48853060a4bcd17c7c https://preview.redd.it/7dcraf9gr4og1.png?width=1106&format=png&auto=webp&s=4c93c635fbc20762a18cc8e137b6a40ee37c470e submitted by /u/catincombatboots [link] [comments]
- Is it possible to pull information from multiple tabs and make it customizable without altering formulas?Apologies for the confusing title, but I'm not sure how else to word it. I work in a sales-focused role, recently at my job we have been required to send out sales recaps to higher ups. We need to calculate how many sales points we make daily along with calculating goals. I am using the web version of excel since I have to share this across a team. My current set up is as follows: - Each employee gets their own tab with a list of products we sell + how many points they are. Throughout the day they enter in what they did and it automatically calculated the points they earned. - I have another tab called "calculator". This combines all of the totals across the tabs into one chart. ex: =sum('employee1!' A1, 'employee2!' A1) and so on. - the final tab pulls the important information from the calculator tab and into the format that they want it in. I've been asked to share this spreadsheet with other locations, but many of my co-workers are unaware of how to set up a spreadsheet like this. I want to make it as user-friendly as possible before sharing it. I want to be able to add/ delete "employee" tabs as needed without having to change formulas on the main "calculator" tab. Is there any way to set up the =sum() function to change based on the number of tabs automatically? submitted by /u/electricpaperclips [link] [comments]
- Tracking totals over all sheets, but from different cellsHi, I'm trying to keep an automated running total on working hours for my project. I have one sheet per day, each with a cell that sums the total hours for that day (reads 40 in my screenshot), dating back to October. I've been tracking this manually with a rather bulky SUM function on a dedicated sheet, and it works just fine, but I'd like to try to automate the grand total to sum each day as it's created, rather than manually adding the cell each time I create a new sheet. The issue I'm running into is that the daily total doesn't land on the same cell every day; I am constantly adding & removing rows as people come & go from the project. There are also multiple cells that read total hours; one for the subcontractor sections, one for my own company's section, and the bottom one which sums the whole day - this is the one I'm trying to track. Is there a way to filter for this cells contents on each sheet based on the Daily Total cell in the bottom right perhaps, even though they're not in the same row? As an aside, I'm not allowed to change the layout to make this easier; this is a standard form at my company and the formatting needs to stay the same. https://preview.redd.it/3giox6bkvtng1.png?width=819&format=png&auto=webp&s=916dd43f9584d1ac3491770ac180ca0b445688d0 submitted by /u/Mental-Screen-1127 [link] [comments]
- Need some assistance easily organizing what is becoming a rather large spreadsheethttps://i.ibb.co/N6kN1bwz/sample.jpg This is an example of a worksheet I am building on Google Sheets. List of recipes I've made and liked in column A, all the ingredients used across them all in row 1 , the amounts of each ingredient that goes into a specific recipe in the cell that corresponds. This is more of a fun project that may be handy for me later, it's not a huge deal if I can't do what I want but it sure would make it easier if I can since this is becoming a pretty big table. What I would like to be able to do is click on a recipe name in column A, and have Excel or Google Sheets hide every cell that does not specify the ingredient needed and the amount needed for that recipe. Is this possible? Ideas how to accomplish this? This submitted by /u/Due-Editor3682 [link] [comments]