ChatterBank3 mins ago
MS Excel 2007
I am trying to create a spreadsheet that will add up certain cells in a column but not all of them. I have 5 columns and 18 rows and wish to take the highest number in each row (across the 5 columns) and add up down the 18 of them. Is there an easy way of doing this? Could it be done highlighting with a colour or other mark?
Answers
Best Answer
No best answer has yet been selected by jeraldo. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.To the right hand side of each row of your table, enter the formula "=max()" and select the row of numbers to go inside the brackets above (e.g. a2:e2)
That will create a sixth column of 18 numbers, each the maximum of their row.
To find the sum of these numbers use the formula "=sum()" and inside the brackets, select the cells that contain the row maximums.
Does that make sense to you?
Can't think of any easy way to highlight the maximum in each row off the top of my head - but I do have a very cumbersome way if you really want to do it.
That will create a sixth column of 18 numbers, each the maximum of their row.
To find the sum of these numbers use the formula "=sum()" and inside the brackets, select the cells that contain the row maximums.
Does that make sense to you?
Can't think of any easy way to highlight the maximum in each row off the top of my head - but I do have a very cumbersome way if you really want to do it.