Excel 2003 - Need Formula Help

W

windsong

I think my brain is frozen this morning!!

I need to input a simple formula and just can't get it to work.

I have four cells in one column that I need to add and then four cells in
another column I need to add and take away from the total of the first group
of 4 cells. I have this

=SUM(A4:A7)-(C4:C7)

and it doesn't work.
 
Top