View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bigdaddy3
 
Posts: n/a
Default average price of 4 columns of figures but some cells can be blank

i need a formula to give me an average price of 4 columns of prices on 4
sheets (30 cells per column)where some cells can be blank,and even some
sheets blank,All cells are formatted as financial but no zeros showing.
-----Is it possible with a macro and if so formula please.
--
BD3