•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I am averaging multiple rows and not all rows have data. I want to apply that result to all rows. Picture attached.
Our take
If you're looking to average multiple rows where not all cells contain data, and want that result to apply across all rows, there’s a straightforward solution. You can use a formula in Column G that mirrors the logic in Column H, ensuring that it accounts for any existing values, even those lower in the dataset. This approach utilizes simple volume weighting, enabling you to drag the formula down seamlessly. Let’s simplify this process and help you achieve the desired outcome efficiently.
Callouts need to be calculated with the formula I have in G2 for each set of data in the data column to its respective callout. Simple Volume Weighting.
I need a formula for G where I can drag it down and it look like what I have in
Column H.
In short, I need Column G to look like how I populated H based on a formula. I am hung up on the order as in there are values low in the rows that need to be applied for the whole callout.
I’m over thinking it. Solutions??
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to apply formula to whole column, when cells are temporarily blank, without dragging down?In column H, I will have the prices of books I'm ordering (I'm a librarian). In column K, I want to have those prices with $2.54 added to each price to reflect the cost of processing. So I have the simple formula =H+2.54, but I want to apply it to every cell in column K. I haven't started ordering books yet, so the cells are all blank. If I just do the drag-down method, every cell will show $2.54, and that will skew other data in the spreadsheet regarding how much has been spent so far. So I want to have the formula apply to all the cells in column K *while leaving the cells temporarily blank*. The tips I've been reading about this are mostly about creating a table, which seems too complicated for an Excel dummy like me. I'm looking for a simple way to do this, if there is one. It seems like the IF or ISBLANK functions might be another way, but if so, I'm hoping someone can give me the exact formula I need to make this happen. I don't have the intuitive Excel skills to figure this out based on the tips I've seen online. Thank you! submitted by /u/_laughterinthedark_ [link] [comments]
- Returning multiple matches per ID (auto-fill when dragged down?)Hi there! I have multiple assigned IDs for a single code so I need to return all matching values, not just one. I also want this to be kind of automated (?) when I drag down the upstream ID column, it can pull all corresponding values, even if they share or don't share the same code I tried using FILTER, but it only spills results in one place and doesn’t carry over properly when dragged down for other rows. I don’t want to adjust ranges every time manually since my data might get longer. Is there a way to make a formula that: works when dragged down, returns multiple matches per ID, and still updates properly even if the data goes beyond the current rows? Left Side = source workbook; Right Side = destinatioon workbook Thank you so much in advance! submitted by /u/jeankrstein [link] [comments]
- What formula should I be using to populate one column’s data automatically based on my entry for another column?Hi! I need some help here. first off, I’m not allowed to use a v-lookup for this file due to some organisational restrictions, so i’m unable to create a table 2 to facilitate the lookup values. I’m only allowed to use table 1 itself, which is where I have to put in all my values. I have been trying to use index/match instead but can’t see to figure the right formula out. so basically, what I need is for my manual input of data in column J to populate the associated remark in column K. • column J input “NA” = column K input “visit 2” • column J input “nil” = column K input “insufficient blood” • column J input “1” = column K input blank these are the only 3 that I require. let’s say I require it for 30 rows. so my range of rows to populate would be K2:K30 based on the directly adjacent data of J2:J30. how can I do this in formula or automation? thanks in advance! submitted by /u/yanny-jo [link] [comments]
- cell not calculating correctlywhat i am trying to accomplish, and i have written and used this formula many times, but not recently, i dont have an old sheet to copy it from, i cant figure out why its not calculating correctily. i need H3 or I3 to show a total percentage, with final value of 1 or 100% of all the rows in F3. i've tried the formula in differt configs, tweaked, adjusted and just can t get it. see pic below for formula im using in H column. i set it up in a few columns so i can test/prove different versions at the same time. i know its something minor i am missing. just need one box, H3 to display total percentage of column F. the formula in I3 works but stops calculating after a certain point, H3 and J3 are both just a mess. any suggestions? working in excel desktop https://preview.redd.it/nshc5dm377ug1.png?width=1153&format=png&auto=webp&s=a618b8a383a23830a11c548aa5d98f0ccfe9e670 submitted by /u/AcidRayn666 [link] [comments]