Forum Discussion

Sally350's avatar
Sally350
Copper Contributor
May 04, 2021
Solved

Ignoring cells with zero in formula range

I am working on a spreadsheet to calculate golf handicaps. I am using the small function to calculate differentials. There can be 1 to 20 entries. When I have less than 20 entries the formula picks u...
  • HansVogelaar's avatar
    May 04, 2021

    Sally350 

    Use

    =SUMPRODUCT(SMALL(F6:INDEX(F6:F25,F26),ROW(INDIRECT("1:" & F27))))

Resources