average price of 4 columns of figures but some cells can be blank
 

The average function will ignore blanks (that is, it won't count them in the
denominator, so you wind up with an average of the non-blank cells). You
probably just need something like
=average(Sheet1!A1:A30,Sheet2!A1:A30,Sheet3!A1:A30 ,Sheet4!A1:A30)

"bigdaddy3" wrote:

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