Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statements | Excel Discussion (Misc queries) | |||
If statements | Excel Discussion (Misc queries) | |||
If then statements | Excel Discussion (Misc queries) | |||
IF Statements | Excel Worksheet Functions | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions |