Thanks, I have to copy the data in Columns A, B, C etc to a single column to
make the array work and then use If statements to put in "" instead of 0 to
make the noblanks work, but once I've done that it works great. It's a
little messy but I'm a lot further ahead than I was!

I'm still looking for an elegant VB solution though that allows me to do the
calculations in VB and requires no cells at all except those for the final
data. I know it's hiding out there somewhere...

Cheers,

Andy





"Gromit" wrote in message
...
Try this formula from Chip Pearson's website.

http://www.cpearson.com/excel/noblanks.htm

I don't think you need VBA.

Cheers,

Gromit



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/