Show subtotal for data filtered/visible only (1 Viewer)

[accessfever]

Hi, I have an excel file of 17000 lines with part numbers and routing operation times. I wanted to have some formula to show the subtotal of a part number's operation hours after the filter instead of to show the total of all parts' operation hours. Is it a way to do that?

 

[NBVC]

Try something like:

=SUMPRODUCT(SUBTOTAL(9,OFFSET($B$1:$B$100,ROW($B$1:$B$100)- MIN(ROW($B$1:$B$100)),,1)),--($A$1:$A$100=X1))

where A1:A100 contain the part numbers and X1 contains part number to match in filtered list... and B1:B100 contains numbers to sum up....

Adjust ranges to suit.