Google Spreadsheet Post #2154
Formula to add cell values in a range BUT only add value up to 5
I have a sheet that I keep soccer scores on for district rankings. One statistic that we must keep is "Goals Scored Maximum 5" and "Goals Against Maximum 5" Is there a way to add the goals per game but only add the values up to 5 in each cell? For example: 5, 9, 6, 1, and 3 would only add to 19 because anything over 5 is not added into the Sum. I do not want it to omit the values if the cell reads greater than 5.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-22-2017
question by Brittany Manning:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/xKcapVNrkv0;context-place=mydiscussionsFormula to add cell values in a range BUT only add value up to 5
I have a sheet that I keep soccer scores on for district rankings. One statistic that we must keep is "Goals Scored Maximum 5" and "Goals Against Maximum 5" Is there a way to add the goals per game but only add the values up to 5 in each cell? For example: 5, 9, 6, 1, and 3 would only add to 19 because anything over 5 is not added into the Sum. I do not want it to omit the values if the cell reads greater than 5.
Please help! Thanks!
No comments:
Post a Comment