For instance, if you want to sum the values in two cells, you can enter the formula =B2+C2, where B2 and C2 are the cell ...

Occasionally, you may find it useful to be able to quickly add sums across tabs. Luckily, Excel has a function for this too. Produced by Daniel Goodman and Walter Hickey. Originally published in ...

Excel's OFFSET function lets you create a reference that ... and the total and average units sold by that employee (using SUM and AVERAGE with OFFSET). First, I will type an employee ID into ...