I have a list of golf rounds data, with handicap differencials in column G. I need, based on the number of rounds in the list, to average a different number of differencials based on how many rounds have been played. I as going to use nested if's - for example:
=IF(G05>0,AVERAGE(G05:G14),IF(G06>0,AVERAGE(G06:G1 4), etc...
This would require about 20 nested IFs.
Guess I misinterpreted what I read about 64 IFs allowed.

Currently, the data is residing in Row 05 to row 24, with the available data ending at row 24 (variable nr of blank lines beginning in row 05). Based on the nr of available lines of data, I need to average a variable nr of cells in column G.

I think the last ELSE argument can point to a continuation cell (to chain together the nested IFs) but not sure how to have the result always end up in the right cell without absolute referencing.


Here is the HELP text that I was referring to. It made me think more than 8 IFs could be nested...

Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.)

Any advise appreciated, thanks in advance.



Jim S