I have two columns: one for cost, the other hours.
I want to first multiply the two numbers in a row and do the same thing for each row. Then I want to add all of that together.
In the uploaded file, you'll see in cell I31 that I've referenced each cell to multiply them and then added them to the next pair of cells down the columns.
I'm thinking there's got to be an easier way to do this instead of hand picking them the way I have it now.
column example.xlsx 10.7KB 195 downloads