•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for Entire Column
Our take
In your estimating project, you can efficiently apply a formula to an entire column to calculate material costs based on quantity and unit cost. By using a formula like `=E1*I1` in the first row of column J, you can then drag the fill handle down to automatically adjust the formula for each subsequent row. This approach ensures that each row reflects its specific quantity and unit cost, streamlining your calculations and enhancing productivity. Explore this method for a more efficient workflow in your project.
Okay so I am doing an estimating project and I am wondering if there is a way to make a formula for an entire column? Each row the numbers would be different, Column E is my quantity and I is my unit cost, J being my material cost(quantity times unit costs or E*I), so can I do this once and make it follow the pattern in the rest of the rows? I was close to it, but it was using the same quantity base for all of the calculations
[link] [comments]
Read on the original site
Open the publisher's page for the full experience