Calculating Costs for Each period

  • Thread starter Svyatoslav Kuznyetsov
  • Start date
S

Svyatoslav Kuznyetsov

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro need for Excell 2003 0
Excell 2003 VBA Code needs 1
permutation of values in 2 dimensional array 1
Macro to hide rows? 1
Consolidate, Lookup and Sum from dates to months 3
How to get a value from 1 table to a 2nd. 15
Column Heading on each row in pivot table 1
create a macro for a combo box to change a pivot table 1

Top