formula

[Guest]

Hey again, everybody has been great at helping with questions, thought I
would come back with a new one to the experts.

I have 7 columns and 5 rows. Lets say that in cell C3 has text in it that
looks like 2-7 and cell D3 has text in it like 2-7 and cell E3 has nothing in
it and cell F3 has 7-3 and cell G3 has nothing in it and cell H3 has 7-3 in
it, and cell I3 has 7-3 in it.
I would like to be able to add the rows across and also be able to add the
columns down. 2-7=5; and 7-3=8, so in cell C10 it should have 34. Depending
on the rest of the rows cells C8, D8,E8, F8, G8, H8, I8 will have numbers
that are added up from the rows abive them; like C8=the sum of
C3+C4+C5+C6+C7. And all these cells have similar entries as shown.

Any help with this would be great and save me a lot of time when filling out
this form.

Thanks in advance chefmike

 

[Biff]

See this:

http://j-walk.com/ss/excel/files/timesht.htm

Biff

 

[Guest]

Thanks Biff for the link, but not quite what i am looking for.