Incredible. I viewed your series on Excel Formula Efficiency and I'm blown away. I totally forgot that Excel 2007 now allows for Sumif(s) whereas 2003 did not hence me using sumproduct. You proved that it's faster and I'm sure going to slowly change all my dashboards to sumifs to speed up calculation.
Thank you! This helped so much.
The Helper Cell is unbelivable. Going to see how I can use it. Love your vids!!
Incredible. I viewed your series on Excel Formula Efficiency and I'm blown away. I totally forgot that Excel 2007 now allows for Sumif(s) whereas 2003 did not hence me using sumproduct. You proved that it's faster and I'm sure going to slowly change all my dashboards to sumifs to speed up calculation.
Thank you! This helped so much.
The Helper Cell is unbelivable. Going to see how I can use it. Love your vids!!
Mascafequeleche 1 year ago
I am glad that this helped. I was similarly happy when I read the white paper that promoted me to make the videos!
ExcelIsFun 1 year ago