Forum Discussion
dlkosko1958
Jan 29, 2020Copper Contributor
Sum of a range of cells, dropping the highest number in the range.
I would like to calculate the sum of a range of cells, dropping the highest number in the range as part of the calculation. How do I write this formula? Thanks!
tauqeeracma
Jan 29, 2020Iron Contributor
Hi dlkosko1958
Assuming your data range is column A, you may try below formula
=SUM(A:A)-MAX(A:A)
Thanks
Tauqeer