I have a data in the following order:-

Book3 | |||||||
---|---|---|---|---|---|---|---|

A | B | C | D | E | |||

2 | FY06 | FY07 | FY08 | ||||

3 | Cost | Identified | 100000 | 200000 | 34000 | ||

4 | Cost | Proposed | 34500 | 345000 | 870000 | ||

5 | Revenue | Implemented | 45000 | 5000 | 86000 | ||

6 | Cost | Approved | 67000 | 76000 | 88000 | ||

7 | Revenue | Proposed | 76000 | 880000 | 56000 | ||

8 | |||||||

Sheet1 |

I need to write a formula to sum i.e. sum the values of FY06-08, if column A is cost and column B is identified...could you please help in writing the formula???

Thanks

Pooja