How to add cells in Excel (screen shots of cell data added up via the SUM formula).

How to Add Cells in Excel to Sum Up Totals Automatically

Excel’s great for displaying data and even better at crunching numbers. Here’s how to add cells in Excel to sum up totals automatically… Even when you change the numbers. A great feature that Excel has to offer is its use of formulas. Since Excel is often used to organize numerical data for a variety of …

Read more

excel sumif

How to Use the SUMIF and SUMIFS Functions in Excel

SUMIF and SUMIFS help Excel users to save time and frustration by making it easy to glean valuable information from complex datasets. You can total and analyze everything from grade values to quarterly earnings without giving yourself a massive headache. In this tutorial, we’re going to cover: The difference between SUMIF and SUMIFS functions. How to use SUMIF …

Read more

International Short Date Formatting for the TEXT Function

I have an Excel workbook that is used in two different regions where the date format is entirely different, the US and the UK. At the top of a report worksheet I use a TEXT function to inform the user of the date range. Here’s what a US user sees: From: 6/6/2011 to 6/10/2011 Here …

Read more

Let Excel Convert Hours Between Two Dates and Times

In a previous post I went on and on about how you can calculate hours between two different dates and times, but Excel does this for you automatically. I’ll use reader comment as my example. A-02.02.2011 10:00 B-05.02.2011 17:00 Please help me to find B-A in hh:mm For clarity I will assume that the date …

Read more

Indent Left and Right to Align Cell Contents

Formatting is second nature with Excel because ergonomically you want people to notice the information in your data and not spend time finding it, either because it doesn’t stand out, or it blurs together. Recently I came across a new wrinkle with the indentation of cell contents and thought to share it with you here. …

Read more