Forum Discussion
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...
To get the sum of Amount" for "Project1" and "S" in Cell H5 you can use the following formula:
=SUMPRODUCT(SUBTOTAL(109,OFFSET(D21:D99999,ROW(D21:D99999)-MIN(ROW(D21:D99999)),,1)), --(B21:B99999="Project1"), --(B21:B99999="S"))
To get the sum of "Amount" for "Project1" and "R" in Cell H6, you can use the following formula:
=SUMPRODUCT(SUBTOTAL(109, OFFSET(D21:D99999, ROW(D21:D99999)-MIN(ROW(D21:D99
untested.
Hope this will help you