I need help with consructing a formula in Excel 2000?

1 ⤊

I need help with consructing a formula in Excel 2000?

In cells C1, C3, C5, & C7, each has the total of 12 other cells.

My question is, how can I write a formula that subtracts the combined sum of cells C3, C5, & C7 from C1 in cell C9?

I'll bet there is a very simple way right in front of my eyes, but I have not been able to figure it out without using a 6th cell that sums up C3 thru C7.

2006-11-04 08:16:55 · 3 answers · asked by Awesome Bill 7 in Computers & Internet ➔ Other - Computers

3 answers

=C1- (C3+C5+C7)

2006-11-04 08:19:58 · answer #1 · answered by icynici 4 · 1⤊ 0⤋

just write in c9
=c1-(c3+c5+c7)

2006-11-04 16:20:09 · answer #2 · answered by aj 4 · 0⤊ 0⤋

=sum((c1-c3)+(c1-c5)+(c1-c7))
or you can do
=sum(c1-(c3+c5+c7))

2006-11-04 16:19:52 · answer #3 · answered by Stuart 7 · 0⤊ 0⤋