F
Funkydan
Hello Every one,
i was wondering if some one can help me, which some coding or
formula,
What is, that I've created a cost sheet, for employees to work on, A
work sheet represents a section within in a breakdown on costing a
projects, (There About 25 Identical cost sheets)
the cost sheet and these fields
| A | B | C
| D | E |
1| QTY Description Unit Cost Total
Cost CGC
2|
CGC Stands for Cost Group code (The Codes are 1 to 14)
What have is a cost group summary sheet as well.
Listed the 1 to 14 with there Description
The cost sheet will look like something like this below
| A | B |
1 | Total Cost
2 |
3 | 01 Equipment
4 | 02 Air Conditioning
5 | 03 Etc
What i would like to happen is that in cell B2 is that it adds all the
items that have CGC 1 assigned to them in the cost sheets
i think it would be some sort of if statement like IF"AllSheets"Column
B"=1 (Add Column D)
Does this make sense?
Can anyone help please
Danny
i was wondering if some one can help me, which some coding or
formula,
What is, that I've created a cost sheet, for employees to work on, A
work sheet represents a section within in a breakdown on costing a
projects, (There About 25 Identical cost sheets)
the cost sheet and these fields
| A | B | C
| D | E |
1| QTY Description Unit Cost Total
Cost CGC
2|
CGC Stands for Cost Group code (The Codes are 1 to 14)
What have is a cost group summary sheet as well.
Listed the 1 to 14 with there Description
The cost sheet will look like something like this below
| A | B |
1 | Total Cost
2 |
3 | 01 Equipment
4 | 02 Air Conditioning
5 | 03 Etc
What i would like to happen is that in cell B2 is that it adds all the
items that have CGC 1 assigned to them in the cost sheets
i think it would be some sort of if statement like IF"AllSheets"Column
B"=1 (Add Column D)
Does this make sense?
Can anyone help please
Danny