Excel SUMIFS公式 [英] Excel SUMIFS formula
问题描述
= SUMIFS(H2:H24,B2:B24,=< day(h1))>
我正在尝试获取H2: H2(本月我的账单费用)加在一起,看看先支付哪些账单,以及我将支付多少钱到下一次支票(每周付费)。
所以H2:H24(票据的美元金额),B2:B24(票据截止日期 - 简单数字1-31),然后h1是(我支付薪水的那一天-9 / 9 / 2016)
可能有一个非常简单的方法,使用不同的声明代替SUMIFS,任何帮助都会很棒,请和谢谢:D
我尝试过:
SUMIFS功能 - Office支持 [ ^ ]
试用和错误。它至少出现0,不是空或错误
你可以使用数组公式: = SUM(IF(
乙
2
=SUMIFS(H2:H24,B2:B24,"=<day(h1)")>
I'm trying to get H2:H2 (My Bill cost for the month) to get added together to see what which bills to pay first and how much I will have carrying over to the next check (paid bi weekly).
So H2:H24 (dollar amount of bills) , B2:B24 (due date of bills--simple numerical 1-31), then h1 is (the day I get paid for that paycheck-9/9/2016)
There could be a really easy way, a different statement to use instead of SUMIFS, any help would be great please and thank you :D
What I have tried:
SUMIFS function - Office Support[^]
Trial and error. it keeps coming out "0" at least, not null or an error
You can use array formula: =SUM(IF(
B
2:
这篇关于Excel SUMIFS公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!