Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Last issue, I wrote about an Ajax-enabled Web application that has the potential to oust, or at least augment, Outlook. This issue, I have another Ajax Web application that hints at what could be done ...

Mac: The "Sum" function in spreadsheets is great, but if you're not the type to do all your list-making in Excel, coder Brett Terpstra built an OS X System Service that allows you to total up any set ...

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

Way back in December, I wrote about Num Sum, a Web-based spreadsheet. Since then, Num Sum has matured and added quite a few features, including the ability to work on Num Sum spreadsheets offline, ...

With spreadsheets, you store and analyze sets of data, which is key in many businesses. Spreadsheets offer a range of automated functions to perform calculations on data in addition to building graphs ...