Conditional sum

[Svorak D]

Hi,

I have time reporting data in the form of a spreadsheet.
It has 4 columns, viz.

Col A is a unique maintenance id assigned for each problem
reported. For this current question this column is not
needed.

Col B is the name of product in which the maintenance is
needed. Thus, it is obvious that col B will have
duplicates.

Col C is the status of the maintenance request, i.e. OPEN
or FIXED.

Col D is the resources required (in mandays) to fix the
problem.

I need a formula wherein I provide the name of a product
and the status of the request, and the formula returns to
me the total of resources required.

all help is useful.

 

[Aladin Akyurek]

=SUMPRODUCT((ProductNameRange=ProductName)*(MaintenanceStatusRange=Status),R
esourceRange)

The formula expects definite ranges, not whole columns like B:B.