三条件不含重复的和?

jylai

A列 条件为  Descr 2 和 Descr 15
B列 条件为  不重复
C列 条件为  Demand
D列总和

inrever

1. =SUM((A2:A25={"Descr 2","Descr 15"})*(COUNTIF(B2:B25,B2:B25)=1)*(C2:C25="Demand")*D2:D25)

复制代码

jylai

inrever 发表于 2024-9-29 08:44

多谢老师您太厉害，感谢您！

灵犀之声

1. =SUM(SUMIFS(D:D,A:A,{"Descr 2","Descr 15"},C:C,"Demand"))

复制代码

mykitami

=SUM(FILTER(D2:D25,(1*MAP(B2:B25,LAMBDA(x,COUNTIF(B2:B25,x)=1))=1)*((A2:A25="Descr 2")+(A2:A25="Descr 15"))*(C2:C25="Demand"),0))

ovxyz

=SUM(((A2:A25="Descr 2")+(A2:A25="Descr 15"))*(C2:C25="Demand")*(COUNTIF(B2:B25,B2:B25)=1)*D2:D25)

秃头发师

=SUM(TAKE(UNIQUE(FILTER(A:D,((A:A="Descr 2")+(A:A="Descr 15"))*(C:C="Demand"))),,-1))

zhangcheng6688

学习一下字典
Sub test()
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
   If arr(i, 1) = "Descr 2" Or arr(i, 1) = "Descr 15" Then
      If arr(i, 3) = "Demand" Then
         If Not d.exists(arr(i, 2)) Then
            m = m + arr(i, 4)
            d(arr(i, 2)) = ""
         End If
      End If
   End If
Next
[f1] = m
End Sub

秃头发师

又理解错了，重来

=SUM(FILTER(D2:D25,((A2:A25="Descr 2")+(A2:A25="Descr 15"))*(COUNTIF(B2:B25,B2:B25)=1)*(C2:C25="Demand")))

niko88819

1. =SUM(NOT(MMULT(N(A2:A25<>{"Descr 2","Descr 15"}),ROW($1:$2)^0)=2)*(COUNTIF(B2:B25,B2:B25)=1)*(C2:C25="Demand")*D2:D25)

复制代码