| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please with If statement / vlookup
=AVGFIRSTFIVEVALS(K6:K7,Feb!K16:K24)
Billy, I added the UDF to the sheet and this my formula but I am getting a #value! in the cell I have two sheets, the other sheet is "Feb"... "Donna" wrote: How do I write an if statement if I only want to get the averages of the first five cells with a value? I will need to look in about 10 cells, but only avg the FIRST 5 with a value. Some will be blank and Some will be on a different sheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
| Using IF statement in a VLOOKUP | Excel Discussion (Misc queries) | |||
| Help with If and Vlookup Statement | Excel Worksheet Functions | |||
| If Statement / VLookup | Excel Worksheet Functions | |||
| Vlookup or If statement Help | Excel Worksheet Functions | |||
Threaded Mode
