sumif and complex sum_range formulae

[caro]

I have Excel 2003 and need to calculate a complex sum_range total within a
sumif function.

My data is as follows:
Col A = 1 of 4 possible text values (in cells A41:A64)
Col D = fraction to be applied in cells D4164
Col F = amount to have the fraction applied to in cells F41:F64

The calculation I require is:
If column A in the cell range = "OTH" then sum up F*D for the relevant rows

I have tried =SUMIF(A41:A64,"OTH",(F41:F64)*(D4164)) but it did not work.

What formula or formulae should I use?

 

[muddan madhu]

try this

=SUMPRODUCT((A41:A64="oth")*(F41:F64)*(D4164))

 

[caro]

Thank you. This has worked perfectly.

try this

=SUMPRODUCT((A41:A64="oth")*(F41:F64)*(D4164))