Forum Discussion
dianakim
Oct 06, 2023Copper Contributor
How can I get sum vale of filter data?
Hi all, after filter period I want to get values of H5 which meet with project1 and S. I've tried combination of subtotal and sum formula like below but it doesn't work because there are mo...
Patrick2788
Oct 06, 2023Silver Contributor
A 365 solution without OFFSET:
=LET(
visible, LAMBDA(project, deta, amount,
IF(AND(project = E1, deta = F1, SUBTOTAL(3, amount) = 1), amount, 0)
),
SUM(MAP(Table1[Project], Table1[deta], Table1[amount], visible))
)