Hi,

I'm dealing with a large amount of raw data which is categorized into a big dashboard using countifs and sumifs.
A full update of all the formulas can take about an hour of 100% CPU calculation time.

Would there be any speed gain by replacing the 5 or 6 parameter countifs & sumifs with taking the data from various pivot tables instead?