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 ...

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by clicking ...

Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel. When you're working with multiple worksheets simultaneously, it can become tedious to ...

To sum and subtract in Google Sheets, use the formula =SUM(x:y) or =MINUS(x,y) in the desired cells and input the relevant values. Press Enter to get the results. Adding up columns or rows of numbers ...

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

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 ...

Enter your data or use an existing data. Type into the cell where you want to place the result =SERIESSUM(A2,0,2,D2:D4). Press Enter to see the result. The result is 0.504711076. There are two other ...

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, ...

Excel spreadsheets are one of the most useful tools to create documents with calculations and data and organize the accounting or VAT tax, among other tasks. Luckily, while working on Excel you can ...

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 ...

Excel workbooks are the next step after you’ve mastered the single Excel spreadsheet. Going back to the ledger idea we used in our Excel spreadsheets guide, think of the workbook as the ledger (or ...