Put the business area you want to find out about in E1, the region in
F1, and this formula in G1:

=SUMPRODUCT((B1:B1000=E1)*(C1:C1000=F1)*(D1:D1000) )

Adjust the ranges to suit, but you can't use complete columns (except
in XL2007).

Hope this helps.

Pete

On Jan 25, 11:01*am, wrote:
Hi, experts

I need to sum a column with values if two conditions are met in two
other columns. Let me explain the case with an example:
I have a list of projects (each project belongs to a business area and
a region). I have the projects in column A, the business area in
column B, the region in column C and the value of the project in
column D.

I need to know e.g. What is the value of the projects in a particular
business area in a particular region.

Thanks for your help

Javi