I am needing my formulas to figure out what the last row of data is to include in the calculation. The data will always start in row 2 but the end row can change every time the source data is refreshed. I found the following on this site: =IFERROR(SUM(INDIRECT("F2:F" & MAX((F:F<>"")*(ROW((F:F))))),0) but am not sure how to incorporate it into my formulas: =AVERAGE(IF((WEEKDAY($A$2:$A$35,2)>5)*($A$2:$A$35<>""),F2:F35)) or if it is the simplest approach to take. Any help from you gurus is much appreciated!