Excel 2003 - Need Formula Help
 

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.

Excel 2003 - Need Formula Help
 

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

"windsong" wrote:

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.

Excel 2003 - Need Formula Help
 

That did it! Thank you so much.

"bpeltzer" wrote:

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

"windsong" wrote:

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.

Excel 2003 - Need Formula Help
 

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



"windsong" wrote:

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.