Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
See this:
http://j-walk.com/ss/excel/files/timesht.htm Biff "chefmike" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Thanks Biff for the link, but not quite what i am looking for.
"Biff" wrote: See this: http://j-walk.com/ss/excel/files/timesht.htm Biff "chefmike" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |