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

[bigdaddy3]

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.

 

[bigdaddy3]

Thanks for your input,but ive got 4 columns on each sheet would it be best to
use your formula but 4 times

 

[bpeltzer]

If the columns are contiguous, you could do something like
=average(Sheet1!A130,Sheet2!A130,Sheet3!A130,Sheet4!A130); if not
then you can call out each range within a single average function:
=average(Sheet1!A1:A30,Sheet1!C1:C30,...)

 

[bigdaddy3]

Thanks for that ill give it a go
--
BD3

If the columns are contiguous, you could do something like
=average(Sheet1!A130,Sheet2!A130,Sheet3!A130,Sheet4!A130); if not
then you can call out each range within a single average function:
=average(Sheet1!A1:A30,Sheet1!C1:C30,...)