sumif and complex sum_range formulae
 

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 D41:D64
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)*(D41:D64)) but it did not work.

What formula or formulae should I use?

sumif and complex sum_range formulae
 

try this

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

On Feb 3, 1:16*pm, caro wrote:
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 D41:D64
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)*(D41:D64)) but it did not work.

What formula or formulae should I use?

sumif and complex sum_range formulae
 

Thank you. This has worked perfectly.

"muddan madhu" wrote:

try this

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

On Feb 3, 1:16 pm, caro wrote:
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 D41:D64
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)*(D41:D64)) but it did not work.

What formula or formulae should I use?