Counting nonblank cells - 3D

Hi,
I have a database imported in Excel, with several hundred worksheets (sheets),each corresponding to a table from that database.I need to count all the nonblank cells for all those worksheets.I use the function DCOUNTA which works fine for one sheet at the time only...Is there any other function(s) which is more suitable for this type of report or the DCOUNTA formula has to be rearranged regarding the "database" definition to include all worksheets at once together ?
Thanks.Regards,Yves.

Hi,

For 3D countif, you need Laurent Longre 's add-in : MoreFunc
http://xcell05.free.fr/english/morefunc/countif.3d.htm

Glad it fixed your problem ...

Thanks for the feedback