The & function

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Using the & function I create lets say A1:A12 in cell B1.
Now I want to simply use the text in this cell to create
an average or sum.

So I want SUM(A1:A12) which if you do SUM(B1) does not
work even though B1=A1:A12.

Does anyone know a way around this?

email me at "dshah" which is at "ideaglobal.com" if you
can please.

Cheers
 
Thank you very much everyone that has posted a reply. If
you were women I would suggest that you have my babies.
 
Dave

Thanks for saying 'Thanks' ! It makes a nice change! I'm not so sure about
the babies bit, though

8-)

Andy.
 
Back
Top