Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficult Fomula
I am trying to keep a running total of weights of material, sorted by
material type on a seperate worksheet (reports worksheet). I have created a table of material types and would like to keep a running monthly total for each material type. Here is my example. In a worksheet (revenue) my material type is listed as below C6:C1129 =gravel =grain =soil I have 20 different types of material with corresponding weights listed in I6:I1129 in the same worksheet. I then have material types listed in rows in a summary table in a seperate worksheet (reports), with the months of the year in columns. Any suggestions would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficult Fomula
hi
sumif... if your type are on revenue!c column and weights on revenue! I column then on your reports sheet.... you said rows so assuming 1 row and gravel = A1 =revenue!C6:C1129,A1,I6:I1129) this would sum all the weights for gravel. you would need a formula for each type and if summing by month, for each month. the month need not be referenced in the formula, just put in the month column. Regards FSt1 "KeK23" wrote: I am trying to keep a running total of weights of material, sorted by material type on a seperate worksheet (reports worksheet). I have created a table of material types and would like to keep a running monthly total for each material type. Here is my example. In a worksheet (revenue) my material type is listed as below C6:C1129 =gravel =grain =soil I have 20 different types of material with corresponding weights listed in I6:I1129 in the same worksheet. I then have material types listed in rows in a summary table in a seperate worksheet (reports), with the months of the year in columns. Any suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fomula (if?) | Excel Worksheet Functions | |||
Copying fomula down... | Excel Discussion (Misc queries) | |||
Fomula | Excel Discussion (Misc queries) | |||
Please help, i need a fomula | Excel Worksheet Functions | |||
IF Fomula | Excel Discussion (Misc queries) |