View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Svyatoslav Kuznyetsov Svyatoslav Kuznyetsov is offline
external usenet poster
 
Posts: 3
Default Calculating Costs for Each period

I have the other problem and I also need a help with this. It will be
very kindly just to tell me what chapter and theme I need to read.
My table is the following(it represents costs of department):
A B C D
E F G
1 Object January
February
2 Dep1 Dep2 Dep3 Dep1
Dep2 Dep3
3 Mater. 100 700
800
4 Fuel 300
700 400
5 Payroll 400 300
What I want in result:
A B C D
1 Object Dep. January February
2 Material Dep1 100
3 Material Dep 3 700
4 Material Dep 2 800
.....
The empty cells shouldn't be represent in results. Thanks for any help