NOTE: I HAVE A GOOGLE SHEET LINK I CAN SEND. HOWEVER, I CANNOT PROVIDE IT AS PART OF THIS LOG-IN (your system keeps preventing me from connecting)
ISSUE: I am looking to create a summary table that dynamically calculates count formulas, sum formulas and sumproduct formulas (see an example of the specific formulas in row 8 of the worksheet titled: "Client distribution_by category") based upon the data presented on a pivot table in a separate worksheet (worksheet titled: "Client distribution_pricing". For transparency, I'm trying to avoid using a macro to do this, but not sure how to go about this problem. Thanks for the help!!!
Solved by O. J. in 30 mins