Hi,
I'm trying to create a formula to sum a row of values greater than zero, and exclude the lowest value greater than 0.
My current formula sums the values and excludes the single lowest value, but I am unable to make sure only values greater than 0 are included.
=SUM(B2:R2,)-SUM(,SMALL(B2:R2,1))
Any assistance would be appreciated.
Bookmarks