按分类 月累计求和

vivi123450

如果没有分类，可以 OFFSET,,, day  
现在有碰到增加条件的问题了

solextrade

=NPV(-2,SUMIFS(H:H,G:G,B2,F:F,"<"&A2-IF({1,0},DAY(A2),-1)))

良良

=SUMIFS(H:H,G:G,B2,F:F,">"&EOMONTH(A2,-1),F:F,"<="&A2)

quqiyuan

=SUMIFS($H:$H,$G:$G,B2,$F:$F,">="&"2022/"&LEFT(C2,FIND("-",C2)-1),$F:$F,"<="&"2022/"&MID(C2,FIND("-",C2)+1,5))

jisijie630

=SUMIFS(H:H,G:G,B2,F:F,">="&TEXT(A2,"e/m")/1,F:F,"<="&A2)

博爱风雨同舟

=SUM((1-ISERR(VDB(,,"22-7-5","22-7-1",F2:F13)))*(G2:G13=B2)*(H2:H13))

vivi123450

良良 发表于 2023-7-2 12:02
=SUMIFS(H:H,G:G,B2,F:F,">"&EOMONTH(A2,-1),F:F,"

a2是2023/7/5，EOMONTH(A2,-1)和最后&A的A2 我全部替换为 EDATE(A2-1,-12),那如果b2里面同时求和  a&b,
=SUMIFS(I:I,H:H,"a",G:G,">"&EOMONTH(EDATE(A2-1,-12),-1),G:G,"<="&EDATE(A2,-12))
+
SUMIFS(I:I,H:H,"b",G:G,">"&EOMONTH(EDATE(A2-1,-12),-1),G:G,"<="&EDATE(A2,-12))
还有更好方法吗

Away.

=SUMIFS(H:H,G:G,B2,F:F,">"&EOMONTH(A2,-1),F:F,"<="&A2)

良良

vivi123450 发表于 2023-7-2 15:38
a2是2023/7/5，EOMONTH(A2,-1)和最后&A的A2 我全部替换为 EDATE(A2-1,-12),那如果b2里面同时求和  a&b,
...

=SUM(SUMIFS(I:I,H:H,{"a";"b"},G:G,">"&EDATE(A2,-12)-DAY(A2),G:G,"<="&EDATE(A2,-12)))

vivi123450

良良 发表于 2023-7-2 16:17
=SUM(SUMIFS(I:I,H:H,{"a";"b"},G:G,">"&EDATE(A2,-12)-DAY(A2),G:G,"

a&b 为单元格内的条件，a2和b2  {a2;b2}这部分是不能用的