My data:
A B C D
D 150 hash123 2/3/2023
D 200 hash999 1/3/2023
D 200 hash999 1/3/2023
E 250 hash321 1/2/2023
E 265 hash954 1/2/2023
D 344 hash004 9/5/2022
B 434 hash075 8/5/2022
A 975 hash749 5/5/2022
C 513 hash304 1/5/2022
B 454 hash926 2/5/2021
For only the unique values in column C, I want to SUM the associated value of the same row in column B, if the value in column A is "D" and the date in column D is within the last 3 months.
So in the above that would be: 150 + 200 = 350.
I was working with COUNTIFS
=COUNTIFS(D:D,">="&EDATE(TODAY(),-3),$A:$A,"D")
, but I think I need to combine it somehow with a =query(unique(C:C),...)
but I don't know if and how.
I already checked here, but that just counts the total unique values. And here, but that does not use unique
.