To get a count of the total number of cells in a range (empty and nonempty cells), use the following formula. This formula returns the number of cells in a range named Data. It simply multiplies the number of rows (returned by the ROWS function) by the number of columns (returned by the COLUMNS function).

=ROWS(Data)*COLUMNS(Data)

This formula will not work if the Data range consists of noncontiguous cells. In other words, Data must be a rectangular range of cells.

• The Physics of Musical Instruments User Reviews Send this to a friend The Physics of Musical Instruments Manufacturer: Springer Customer Rating: List Price: $99.00 Sale...
• USA - MS: Autologous Stem Cell Transplants, Visible Progress in 8 of 10 Patients Image via Wikipedia Transplanting stem cells from one’s own bone marrow (autologous stem cell transplants) improves the symptoms of muscular...
• How to Clean Up Outlook Contact Phone Numbers using VBA Introduction [/caption] I got a new phone and when synchronised with Microsoft Outlook, the phone numbers don't dial out properly...
• Adwords Key Phrase Research For Inexperienced Persons While you embark to your first PPC adventure, you wish to have to keep a small number of keywords at...
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet,...