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