Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

This is the demonstration file to accompany the article, How to calculate conditional subtotals in an Excel revenue sheet, by Susan Harkins.

I used Excel 2013 on Windows 7, but the instructions for all three ribbon versions are virtually the same. In Excel 2003, you'll find Subtotals on the Data menu.

I used Excel 2013 on Windows 7, but the instructions for all three ribbon versions are virtually the same. In Excel 2003, you'll find Subtotals on the Data menu. While the example file is simple, ...

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

I used Excel 2013 on Windows 7, but the instructions for all three ribbon versions are virtually the same. In Excel 2003, you'll find Subtotals on the Data menu.