ExcelBanter - If Statements HELP !

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statements HELP ! (https://www.excelbanter.com/excel-discussion-misc-queries/258544-if-statements-help.html)

Donna

If Statements HELP !

=IF(K7="","",((Jan!K23+Jan!K24+Jan!K25+K6+K7)/5))
How would I write this If Statement if I wanted it to actually start on row
28 of the Jan sheet and keep going up till it finds values, (but then I only
want the first 5 values avg, including those on the other sheet)

All times are GMT +1. The time now is 04:13 PM.