Hi,
I have anexcel file with data of type:
500 200 2000
1000 0 6000
ranging from cell C7 to AL37.
I have been trying to return the maximum of two cells (same column, different rows), add the results and return in a different ceel e.g. if i consider the sample above then i will like it to return:
1000 + 200 + 6000.
I tried to use
SUM(MAX(C7;C8):MAX(AL7:AL8) to return the reults for two rows, but it only compute the first and last column. Is there a way i can compute all the columns without having to explicitly specify them out?
Thanks in Advance
Manywise
Bookmarks