the wb attached is currently filtered. Column K indicates the status of the position. In cell T15, i would like to know the total amount of all filtered data for positions that are currently open. Vice versa I would like to do the same for all filtered data currently closed.
Can someone assist with a vba code or formula. Thanks