Hi all...new to the forum and wondering if someone can help me before I go completely mad!!
I am trying to generate a spreadsheet whereby weekly golf scores can be added for a number of individuals, with the last n number of scores being added together. The difficulty I am having is that n is generated from another formula in a cell, and will change. Also, the row where the weekly scores will be added, will have some blanks as players do not play every weekend...so blanks need to be ignored.
Anyone any idea how I can do this?
Thank you in advance.
Bookmarks