View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donna Donna is offline
external usenet poster
 
Posts: 180
Default Help Please with If statement / vlookup

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