Simple addition

H

Harry "G"

I am new to this excel stuff and trying to get a total six (6) row
across (every other one) and cannot get it to work for example I a
using the following formula: =Sum(d7:f7:h7:j7:l7:n7) I am doing this a
rows c,e,g,i,k & m have other numbers and I want the end results to b
% of these two different totals!
Any help would be greatly appreciated!
The first set of additions c,e, g, etc. are coming out ok, but when
put the other formula in I am getting a number without any numbers i
the rows. Hope you follow what I am saying
 
F

Freemini

your formula in cell O7 should read :
=SUM(C7,E7,G7,I7,K7,M7)
and in P7
=SUM(D7,F7,H7,J7,L7,N7)

your orignal formula was for inclusive cells, hence the total in P
when the cells D7 etc had no values.

hth

Mik
 
Top