Hi Afolabi,

If you don't want to use VBA (create a UDF), you could review the following
pages:
http://www.jkp-ads.com/Articles/ExcelNames08.htm
http://www.jkp-ads.com/Articles/ExcelNames09.htm

In any case, there is a fundamental issue with both approaches: since
hiding/unhiding rows doesn't trigger any event, such event will have to be
forced from time to time, or maybe you can leave with the formulae updating
their result in the next recalculation of the sheet.

Regards,
KL


"Afolabi" wrote in message
...
I have some rows manually hidden, Please is there a formula I can apply to
return the sum of the unhidden data contain in a column?