| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif with multiple columns in sum_range | Excel Discussion (Misc queries) | |||
| Sumif with multiple columns in sum_range | Excel Worksheet Functions | |||
| SUMIF - Sum_Range is misleading | Excel Worksheet Functions | |||
| SUMIF with the Sum_range across several colums | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
