Hello,

This is a simplified example, but using this table I would like to find the average of their subtractions.

A B
4 1
3 1
2 1
1 1

I am looking for a single cell formula that would do "=average(4 - 1, 3 - 1, 2 - 1, 1 - 1)"

What I have been doing up to this point is creating another column of subtractions and then averaging that, but I would like to get rid of this extra column (which actually ends up being several columns with all my data) and replace it with a single cell formula is possible.

Thanks for the help,
Boyd

Excel 2003, Windows XP