If Statements HELP !

D

Donna

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

*** HeLp with Array formula 4
Page numbering with Merged Document and IF statements 1
Subtotal and IF Formula 1
how to use if statements or vlookups 0
Sort, select and average macro help 2
Cell Value to remain constant 4
if statements using words 2
Rolling Averages? 5

Top