Thread: IMSUB of Multiple Cells

I feel as though i may be missing something. I have been trying all afternoon to work on formulas in Excell 2010 and it has not been going very well, I get the basics of the formula process, but what im trying to master is subtracting an entire column of cells from another column of cells. Every time i do exactly what the tutorials tell me it ends up with an error message. Here is what im doing maybe someone can tell me where im going wrong. on a side note, i began doing this with currencys but thought maybe that was the problem so now im trying the general formatting.

A B
26 13
12 5
67 14
23 32
99 4

I want to get the sum of colum b subtracted from column a so i type into C7;

=IMSUB(A2:A6,B2:B4)

and the sum i get in C7 is #VALUE!

I have tried it adding a subtraction sign before B2 and still the same thing occurs.

PLEASE HELP!!!!