P
Prinsen
Hi.
I´ve been knocking my head black and blue in desperation...
How can I sum orders from a spec month in a table?
Cheet A look like this:
Col 1: Number of order
Col2: Date
Col3: Status (A or B)
Col4: Projectname
Col5: orderamount
I want to sum all order from ex nov 2006 into a cell in another cheet (cheet
B).
My next problem is to sum all orderamount from a spec moutn by Status (A or
B).
ex. 12 $ in nov 06 and another 14 $ in nov 06 should be sum into 26 $ for
nov 06 in the cell on the other cheet.
ex. even status should be sum into colums like this:
Cheet B
Col1: Date each month (ex. nov06, dec 06, jan07 etc)
Col2: A project (in $)
Col3: B projekt (in $)
Col4: A+B projekt (in $)
Hope yuo understand my english (I´m from Sweden)...
I would be the happiest man in the world if someone could help me...
I´ve been knocking my head black and blue in desperation...
How can I sum orders from a spec month in a table?
Cheet A look like this:
Col 1: Number of order
Col2: Date
Col3: Status (A or B)
Col4: Projectname
Col5: orderamount
I want to sum all order from ex nov 2006 into a cell in another cheet (cheet
B).
My next problem is to sum all orderamount from a spec moutn by Status (A or
B).
ex. 12 $ in nov 06 and another 14 $ in nov 06 should be sum into 26 $ for
nov 06 in the cell on the other cheet.
ex. even status should be sum into colums like this:
Cheet B
Col1: Date each month (ex. nov06, dec 06, jan07 etc)
Col2: A project (in $)
Col3: B projekt (in $)
Col4: A+B projekt (in $)
Hope yuo understand my english (I´m from Sweden)...
I would be the happiest man in the world if someone could help me...