解释:SUMPRODUCT((R2C1:R500C1=RC[-21])*(R2C21:R500C21 >RC[-1]))
时间: 2023-11-06 11:06:17 浏览: 22
这个公式的作用是计算在一个区域内,第1列的值等于当前单元格左侧第21列的值,并且第21列到当前单元格左侧第1列的值大于当前单元格左侧第1列的值的所有单元格的乘积之和。其中,R2C1:R500C1表示第1列的范围,RC[-21]表示当前单元格左侧第21列的单元格,R2C21:R500C21表示第21列的范围,RC[-1]表示当前单元格左侧第1列的单元格。SUMPRODUCT函数将满足条件的单元格的乘积相加,得出最终结果。
相关问题
解释:SUMPRODUCT((R2C1:R" & FinalRow & "C1=RC[-21])*(R2C21:R" & FinalRow & "C21 >RC[-1]))。 其中FinalRow变量表示最后一行的行号
Unfortunately, the question is incomplete and there is no way to provide an explanation. The formula provided is incomplete as it ends with "R" and does not provide any operation or range to sum the product of. Please provide a complete formula for further assistance.
解释:SUMPRODUCT((R2C1:R" & FinalRow & "C1=RC[-21])*(R2C21:R" & FinalRow & "C21 >RC[-1])) 。其中FinalRow变量表示最后一行的行号。
Unfortunately, the question is incomplete and the formula provided is cut off. Please provide the full formula and context to receive an accurate answer.