Hi there,
I my Excel file which contains a pivot table I have this formula which calculates the average in the last (grand total) table.
The formula works for now, but tommorow or every other day this cell can be moved to say "F" or "G" or whatever.
Is there a way to let excel determine in which colomn the (grand total) stands (D,E,F,G,....etc) and use this in my average formula?
I my Excel file which contains a pivot table I have this formula which calculates the average in the last (grand total) table.
The formula works for now, but tommorow or every other day this cell can be moved to say "F" or "G" or whatever.
Is there a way to let excel determine in which colomn the (grand total) stands (D,E,F,G,....etc) and use this in my average formula?
Code:
=AVERAGE(INDIRECT("E5:E"&(4+COUNT(A:A))))