Hello,
I have a table that has filters applied to it based off of which configuration (column C value) is entered. I am wanting to sum the quantity (column D) of only the cells that have not been filtered out of each configuration in D107:D114. I am also wanting to separate the total quantity based off of the value in column A. Attached is a copy of the file that I am trying to work with.
Formula that I have tried to use.
=SUMPRODUCT(SUBTOTAL(109,OFFSET(D3,ROW(D3:D105)-ROW(D3),0)),(A3:A105=D107))
Thank you,
Eric
Bookmarks