Subtraction, division, multiplication of ranges

Is there a function, perhaps similar to the Auto Sum function, that enables users to subtract, divide or multiply cell ranges? If not, what is the fastest way to perform these calculations?

You probably need an array formula, but it is not 100% clear what you are doing

Let's say in Column A you have (down the column)
1
2
3
4

and in column B you have (down the column)

5
6
7
8

and you want to know what is 1*5 + 2*6 + 3*7 + 4*8

Then this formula will do this
{=SUM(A1:A4*B1:B4)}

This is an array formula. So you need to just enter =SUM(A1:A4*B1:B4) and then instead of pressing Enter, you press Ctrl-Shift-Enter

For a good read, have a look here http://www.cpearson.com/excel/array.htm

Or this non array

=SUMPRODUCT(--(A1:A4)*(--(B1:B4)))

VBA Noob