英文:
Summing up multiple functions based on conditions in multiple arrays in Excel
问题
我试图做的是，如果一个产品是企业级并且已经激活超过12个月，就将第4列的收入乘以激活的月数。然后将满足条件的所有行相加，以得到最终值。我尝试了将多个SUMIFS函数组合在一起，但它给我错误的值。我不能在SUMIFS函数中将函数作为sum数组输入，但如果可以的话，它会起作用。
我尝试了多个SUMIFS函数，并在sum数组中添加了乘法函数。我还尝试了几个SUMPRODUCT函数。
英文:
What I am trying to do is if a Product is Enterprise and has been active for over 12 months multiply the revenue in column 4 by the amount of months active. Then sum up all of the rows that meet the criteria together to get a final value. I have tried combining multiple SUMIFS functions together but it gives me the wrong value. I cant have a function as the sum array input in a sumifs fuction but if I could it would work.
I tried multiple SUMIFS functions and adding the multiplication function in the sum array. I also tried several sumproduct functions.
答案1
得分: 1
=SUMPRODUCT((A2:A8="Enterprise")(C2:C8>12)(D2:D8)*(C2:C8))
英文:
Take a look at SUMPRODUCT: sumproduct
=SUMPRODUCT((A2:A8="Enterprise")*(C2:C8>12)*(D2:D8)*(C2:C8))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论